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

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

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

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

52: -- call to this function. Just return the value in the global
53: -- variable.
54: --
55: l_legislation_code := g_legislation_code;
56: hr_utility.set_location(l_proc, 20);
57: else
58: --
59: -- The ID is different to the last call to this function
60: -- or this is the first call to this function.

Line 69: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

65: close csr_leg_code;
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
70: hr_utility.raise_error;
71: end if;
72: --
73: close csr_leg_code;

Line 70: hr_utility.raise_error;

66: --
67: -- The primary key is invalid therefore we must error
68: --
69: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
70: hr_utility.raise_error;
71: end if;
72: --
73: close csr_leg_code;
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

70: hr_utility.raise_error;
71: end if;
72: --
73: close csr_leg_code;
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);
75: --
76: g_person_extra_info_id := p_person_extra_info_id;
77: g_legislation_code := l_legislation_code;
78: end if;

Line 80: hr_utility.set_location(' Leaving:'|| l_proc, 25);

76: g_person_extra_info_id := p_person_extra_info_id;
77: g_legislation_code := l_legislation_code;
78: end if;
79: --
80: hr_utility.set_location(' Leaving:'|| l_proc, 25);
81: --
82: return l_legislation_code;
83: end return_legislation_code;
84: --

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

120: l_argument varchar2(30);
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'|| l_proc,10);
125: --
126: -- Only proceed with validation if a row exists for
127: -- the current record in the HR Schema.
128: if not pe_pei_shd.api_updating

Line 132: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

128: if not pe_pei_shd.api_updating
129: (p_person_extra_info_id => p_rec.person_extra_info_id
130: ,p_object_version_number => p_rec.object_version_number
131: ) then
132: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
133: hr_utility.set_message_token('PROCEDURE', l_proc);
134: hr_utility.set_message_token('STEP', '20');
135: end if;
136: --

Line 133: hr_utility.set_message_token('PROCEDURE', l_proc);

129: (p_person_extra_info_id => p_rec.person_extra_info_id
130: ,p_object_version_number => p_rec.object_version_number
131: ) then
132: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
133: hr_utility.set_message_token('PROCEDURE', l_proc);
134: hr_utility.set_message_token('STEP', '20');
135: end if;
136: --
137: hr_utility.set_location (l_proc, 30);

Line 134: hr_utility.set_message_token('STEP', '20');

130: ,p_object_version_number => p_rec.object_version_number
131: ) then
132: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
133: hr_utility.set_message_token('PROCEDURE', l_proc);
134: hr_utility.set_message_token('STEP', '20');
135: end if;
136: --
137: hr_utility.set_location (l_proc, 30);
138: --

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

133: hr_utility.set_message_token('PROCEDURE', l_proc);
134: hr_utility.set_message_token('STEP', '20');
135: end if;
136: --
137: hr_utility.set_location (l_proc, 30);
138: --
139: if nvl(p_rec.person_id,hr_api.g_number)
140: <> nvl(pe_pei_shd.g_old_rec.person_id,hr_api.g_number) then
141: l_argument := 'person_id';

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

147: l_argument := 'information_type';
148: raise l_error;
149: end if;
150: --
151: hr_utility.set_location(' Leaving : '|| l_proc, 40);
152: --
153: exception
154: when l_error then
155: hr_api.argument_changed_error

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

200: FROM per_all_people_f per -- Bug 4508101
201: WHERE per.person_id = p_person_id;
202: --
203: begin
204: hr_utility.set_location('Entering:'||l_proc, 10);
205: --
206: -- Check mandatory parameters have been set
207: --
208: hr_api.mandatory_arg_error

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

211: p_argument => 'person_id',
212: p_argument_value => p_person_id
213: );
214: --
215: hr_utility.set_location(l_proc, 20);
216: --
217: -- Now check to see if the person exists
218: --
219: for csr_person_id_rec in csr_person_id loop

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

217: -- Now check to see if the person exists
218: --
219: for csr_person_id_rec in csr_person_id loop
220: --
221: hr_utility.set_location(l_proc, 30);
222: --
223: l_person_found := true;
224: exit;
225: end loop;

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

223: l_person_found := true;
224: exit;
225: end loop;
226: --
227: hr_utility.set_location(l_proc, 40);
228: --
229: if not l_person_found then
230: --
231: hr_utility.set_location(l_proc, 50);

Line 231: hr_utility.set_location(l_proc, 50);

227: hr_utility.set_location(l_proc, 40);
228: --
229: if not l_person_found then
230: --
231: hr_utility.set_location(l_proc, 50);
232: --
233: hr_utility.set_message(800, 'HR_INV_PERSON');
234: hr_utility.raise_error;
235: end if;

Line 233: hr_utility.set_message(800, 'HR_INV_PERSON');

229: if not l_person_found then
230: --
231: hr_utility.set_location(l_proc, 50);
232: --
233: hr_utility.set_message(800, 'HR_INV_PERSON');
234: hr_utility.raise_error;
235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 60);

Line 234: hr_utility.raise_error;

230: --
231: hr_utility.set_location(l_proc, 50);
232: --
233: hr_utility.set_message(800, 'HR_INV_PERSON');
234: hr_utility.raise_error;
235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 60);
238: --

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

233: hr_utility.set_message(800, 'HR_INV_PERSON');
234: hr_utility.raise_error;
235: end if;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 60);
238: --
239: end chk_person_id;
240: --
241: -- ----------------------------------------------------------------------------

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

291: WHERE pei.information_type = p_information_type
292: AND pei.person_id = p_person_id ;
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Check mandatory parameters have been set
298: --
299: hr_api.mandatory_arg_error

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

302: p_argument => 'information_type',
303: p_argument_value => p_information_type
304: );
305: --
306: hr_utility.set_location(l_proc, 7);
307: --
308: for csr_info_type_rec in csr_info_type loop
309: --
310: hr_utility.set_location(l_proc, 10);

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

306: hr_utility.set_location(l_proc, 7);
307: --
308: for csr_info_type_rec in csr_info_type loop
309: --
310: hr_utility.set_location(l_proc, 10);
311: --
312: -- We would only come here if the information type was valid if it is not
313: -- valid then we do not want to do the following checks. We will leave the FK
314: -- to be checked by the constraint PER_PEOPLE_EXTRA_INFO_FK1 at DML time

Line 321: hr_utility.set_location(l_proc, 15);

317: -- Check to see the info type is still active
318: --
319: if csr_info_type_rec.active_inactive_flag = 'N' then
320: --
321: hr_utility.set_location(l_proc, 15);
322: --
323: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
324: hr_utility.raise_error;
325: end if;

Line 323: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');

319: if csr_info_type_rec.active_inactive_flag = 'N' then
320: --
321: hr_utility.set_location(l_proc, 15);
322: --
323: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
324: hr_utility.raise_error;
325: end if;
326: --
327: -- If multiple ocurrences flag says N(o) then there is not allowed to be a

Line 324: hr_utility.raise_error;

320: --
321: hr_utility.set_location(l_proc, 15);
322: --
323: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
324: hr_utility.raise_error;
325: end if;
326: --
327: -- If multiple ocurrences flag says N(o) then there is not allowed to be a
328: -- record already on the EXTRA_INFO table

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

326: --
327: -- If multiple ocurrences flag says N(o) then there is not allowed to be a
328: -- record already on the EXTRA_INFO table
329: --
330: hr_utility.set_location(l_proc, 20);
331: --
332: if csr_info_type_rec.multiple_occurences_flag = 'N' THEN
333: --
334: hr_utility.set_location(l_proc, 25);

Line 334: hr_utility.set_location(l_proc, 25);

330: hr_utility.set_location(l_proc, 20);
331: --
332: if csr_info_type_rec.multiple_occurences_flag = 'N' THEN
333: --
334: hr_utility.set_location(l_proc, 25);
335: --
336: for csr_extra_info_rec in csr_extra_info loop
337: --
338: hr_utility.set_location(l_proc, 30);

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

334: hr_utility.set_location(l_proc, 25);
335: --
336: for csr_extra_info_rec in csr_extra_info loop
337: --
338: hr_utility.set_location(l_proc, 30);
339: --
340: -- If we are here the multiple ocurrences flag is N and there
341: -- already exists a record on the EXTRA_INFO table for the given
342: -- person and info type

Line 355: hr_utility.set_message(800, 'HR_PEI_MORE_THAN_1_RECORD');

351: end if;
352: --
353: -- Otherwise let the generic message be raised.
354: --
355: hr_utility.set_message(800, 'HR_PEI_MORE_THAN_1_RECORD');
356: hr_utility.raise_error;
357: --
358: end loop;
359: --

Line 356: hr_utility.raise_error;

352: --
353: -- Otherwise let the generic message be raised.
354: --
355: hr_utility.set_message(800, 'HR_PEI_MORE_THAN_1_RECORD');
356: hr_utility.raise_error;
357: --
358: end loop;
359: --
360: end if;

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

360: end if;
361: --
362: end loop;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: --
366: End chk_information_type;
367: --
368: -- -----------------------------------------------------------------------

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

397: --
398: l_proc varchar2(72) := g_package||'chk_df';
399: --
400: begin
401: hr_utility.set_location('Entering:'||l_proc, 10);
402: --
403: if ((p_rec.person_extra_info_id is not null) and (
404: nvl(pe_pei_shd.g_old_rec.pei_attribute_category, hr_api.g_varchar2) <>
405: nvl(p_rec.pei_attribute_category, hr_api.g_varchar2) or

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

496: ,p_attribute20_name => 'PEI_ATTRIBUTE20'
497: ,p_attribute20_value => p_rec.pei_attribute20);
498: end if;
499: --
500: hr_utility.set_location(' Leaving:'||l_proc, 20);
501: end chk_df;
502: --
503: -- -----------------------------------------------------------------------
504: -- |------------------------------< chk_ddf >----------------------------|

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

537: l_proc varchar2(72) := g_package||'chk_ddf';
538: l_error exception;
539: --
540: Begin
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Check if the row is being inserted or updated and a
544: -- value has changed
545: --

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

677: );
678: --
679: end if;
680: --
681: hr_utility.set_location(' Leaving:'||l_proc, 10);
682: end chk_ddf;
683: --
684: -- ----------------------------------------------------------------------------
685: -- |---------------------------< insert_validate >----------------------------|

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

688: --
689: l_proc varchar2(72) := g_package||'insert_validate';
690: --
691: Begin
692: hr_utility.set_location('Entering:'||l_proc, 5);
693: --
694: per_per_bus.set_security_group_id
695: (
696: p_person_id => p_rec.person_id

Line 699: hr_utility.set_location('Entering:'||l_proc, 7);

695: (
696: p_person_id => p_rec.person_id
697: );
698: --
699: hr_utility.set_location('Entering:'||l_proc, 7);
700: --
701: -- Call all supporting business operations
702: --
703: -- 1) Check person id

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

704: --
705: pe_pei_bus.chk_person_id
706: (p_person_id => p_rec.person_id);
707: --
708: hr_utility.set_location(l_proc, 10);
709: --
710: -- 2) Check information type
711: --
712: pe_pei_bus.chk_information_type

Line 716: hr_utility.set_location(l_proc, 15);

712: pe_pei_bus.chk_information_type
713: (p_information_type => p_rec.information_type
714: ,p_person_id => p_rec.person_id);
715: --
716: hr_utility.set_location(l_proc, 15);
717: --
718: -- 3) Call ddf procedure to validation Developer Descriptive Flexfields
719: --
720: pe_pei_bus.chk_ddf(p_rec => p_rec);

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

722: -- Call df procedure to validation Descriptive Flexfields
723: --
724: pe_pei_bus.chk_df(p_rec => p_rec);
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 30);
727: --
728: End insert_validate;
729: --
730: -- ----------------------------------------------------------------------------

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

734: --
735: l_proc varchar2(72) := g_package||'update_validate';
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: per_per_bus.set_security_group_id
741: (
742: p_person_id => p_rec.person_id

Line 745: hr_utility.set_location('Entering:'||l_proc, 7);

741: (
742: p_person_id => p_rec.person_id
743: );
744: --
745: hr_utility.set_location('Entering:'||l_proc, 7);
746: --
747: -- Call all supporting business operations
748: --
749: -- 1) Check those columns which cannot be updated have not changed.

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

747: -- Call all supporting business operations
748: --
749: -- 1) Check those columns which cannot be updated have not changed.
750: --
751: hr_utility.set_location(l_proc, 10);
752: --
753: pe_pei_bus.chk_non_updateable_args (p_rec => p_rec);
754: --
755: -- 2) Call ddf procedure to validation Developer Descriptive Flexfields

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

759: -- Call df procedure to validation Descriptive Flexfields
760: --
761: pe_pei_bus.chk_df(p_rec => p_rec);
762: --
763: hr_utility.set_location(' Leaving:'||l_proc, 30);
764: End update_validate;
765: --
766: -- ----------------------------------------------------------------------------
767: -- |---------------------------< delete_validate >----------------------------|

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

770: --
771: l_proc varchar2(72) := g_package||'delete_validate';
772: --
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 10);
779: End delete_validate;
780: --
781: end pe_pei_bus;