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

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

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

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: */

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

96: l_legislation_code varchar2(150);
97: l_proc varchar2(72) := g_package||'return_legislation_code';
98: Begin
99: --
100: hr_utility.set_location('Entering:'||l_proc, 5);
101: hr_api.mandatory_arg_error(p_api_name => l_proc
102: ,p_argument => 'assignment_extra_info_id'
103: ,p_argument_value => p_assignment_extra_info_id
104: );

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

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

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

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

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

137: close csr_leg_code;
138: pe_aei_bus.g_assignment_extra_info_id := p_assignment_extra_info_id;
139: pe_aei_bus.g_legislation_code := l_legislation_code;
140: end if;
141: hr_utility.set_location(' Leaving:'|| l_proc, 40);
142: return l_legislation_code;
143: end return_legislation_code;
144: --
145: --

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

189: from per_assignment_info_types aeit
190: where aeit.information_type = code;
191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc, 1);
194: --
195: -- Check mandatory parameters have been set
196: --
197: hr_api.mandatory_arg_error

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

200: p_argument => 'information_type',
201: p_argument_value => p_information_type
202: );
203: --
204: hr_utility.set_location(l_proc, 2);
205: hr_utility.set_location('p_inf_type: '||p_information_type||' '||l_proc, 2);
206: --
207: -- Check that the ACTIVE_INACTIVE_FLAG of assignment
208: -- Information type is active.

Line 205: hr_utility.set_location('p_inf_type: '||p_information_type||' '||l_proc, 2);

201: p_argument_value => p_information_type
202: );
203: --
204: hr_utility.set_location(l_proc, 2);
205: hr_utility.set_location('p_inf_type: '||p_information_type||' '||l_proc, 2);
206: --
207: -- Check that the ACTIVE_INACTIVE_FLAG of assignment
208: -- Information type is active.
209: --

Line 214: hr_utility.set_message(800, 'HR_INV_INFO_TYPE 2');

210: open c_asg_info_type (p_information_type);
211: fetch c_asg_info_type into l_flag;
212: if c_asg_info_type%notfound then
213: close c_asg_info_type;
214: hr_utility.set_message(800, 'HR_INV_INFO_TYPE 2');
215: hr_utility.raise_error;
216: end if;
217: close c_asg_info_type;
218: --

Line 215: hr_utility.raise_error;

211: fetch c_asg_info_type into l_flag;
212: if c_asg_info_type%notfound then
213: close c_asg_info_type;
214: hr_utility.set_message(800, 'HR_INV_INFO_TYPE 2');
215: hr_utility.raise_error;
216: end if;
217: close c_asg_info_type;
218: --
219: if l_flag = 'N' then

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

216: end if;
217: close c_asg_info_type;
218: --
219: if l_flag = 'N' then
220: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
221: hr_utility.raise_error;
222: end if;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 221: hr_utility.raise_error;

217: close c_asg_info_type;
218: --
219: if l_flag = 'N' then
220: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
221: hr_utility.raise_error;
222: end if;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 4);
225: --

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

220: hr_utility.set_message(800, 'HR_INACTIVE_INFO_TYPE');
221: hr_utility.raise_error;
222: end if;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 4);
225: --
226: End chk_assignment_info_type;
227: --
228: -- ----------------------------------------------------------------------------

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

270: from per_all_assignments_f asg
271: where asg.assignment_id = id;
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 1);
275: --
276: -- Check mandatory parameters have been set
277: --
278: hr_api.mandatory_arg_error

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

281: p_argument => 'assignment_id',
282: p_argument_value => p_assignment_id
283: );
284: --
285: hr_utility.set_location(l_proc, 2);
286: --
287: -- Check that the assignment_id is in the per_assignments table.
288: --
289: open c_valid_asg (p_assignment_id);

Line 293: hr_utility.set_message(800, 'HR_INV_ASG_ID');

289: open c_valid_asg (p_assignment_id);
290: fetch c_valid_asg into l_dummy;
291: if c_valid_asg%notfound then
292: close c_valid_asg;
293: hr_utility.set_message(800, 'HR_INV_ASG_ID');
294: hr_utility.raise_error;
295: end if;
296: close c_valid_asg;
297: --

Line 294: hr_utility.raise_error;

290: fetch c_valid_asg into l_dummy;
291: if c_valid_asg%notfound then
292: close c_valid_asg;
293: hr_utility.set_message(800, 'HR_INV_ASG_ID');
294: hr_utility.raise_error;
295: end if;
296: close c_valid_asg;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 3);

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

294: hr_utility.raise_error;
295: end if;
296: close c_valid_asg;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 3);
299: --
300: End chk_assignment_id;
301: --
302: -- ----------------------------------------------------------------------------

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

352: where information_type = code
353: and assignment_id = id;
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: open c_multi_occur_flag (p_information_type);
359: fetch c_multi_occur_flag into l_multi_occur_flag;
360: --

Line 366: hr_utility.set_message(800, 'HR_INV_INFO_TYPE 3');

362: -- chk_information_type should capture this error.
363: --
364: if c_multi_occur_flag%notfound then
365: close c_multi_occur_flag;
366: hr_utility.set_message(800, 'HR_INV_INFO_TYPE 3');
367: hr_utility.raise_error;
368: end if;
369: --
370: close c_multi_occur_flag;

Line 367: hr_utility.raise_error;

363: --
364: if c_multi_occur_flag%notfound then
365: close c_multi_occur_flag;
366: hr_utility.set_message(800, 'HR_INV_INFO_TYPE 3');
367: hr_utility.raise_error;
368: end if;
369: --
370: close c_multi_occur_flag;
371: --

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

368: end if;
369: --
370: close c_multi_occur_flag;
371: --
372: hr_utility.set_location(l_proc, 10);
373: --
374: open c_get_row(p_information_type, p_assignment_id);
375: fetch c_get_row into l_dummy;
376: if c_get_row%notfound then

Line 384: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');

380: end if;
381: close c_get_row;
382: --
383: if l_found_poi and l_multi_occur_flag = 'N' then
384: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
385: hr_utility.raise_error;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 385: hr_utility.raise_error;

381: close c_get_row;
382: --
383: if l_found_poi and l_multi_occur_flag = 'N' then
384: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
385: hr_utility.raise_error;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 15);
389: --

Line 388: hr_utility.set_location(' Leaving:'||l_proc, 15);

384: hr_utility.set_message(800, 'HR_MORE_THAN_1_EXTRA_INFO');
385: hr_utility.raise_error;
386: end if;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 15);
389: --
390: End chk_multiple_occurences_flag;
391: --
392: -- ----------------------------------------------------------------------------

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

425: l_error exception;
426: l_argument varchar2(30);
427: --
428: Begin
429: hr_utility.set_location('Entering:'||l_proc, 10);
430: --
431: -- Only proceed with validation if a row exists for
432: -- the current record in the HR Schema
433: --

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

433: --
434: if not pe_aei_shd.api_updating
435: (p_assignment_extra_info_id => p_rec.assignment_extra_info_id
436: ,p_object_version_number => p_rec.object_version_number) then
437: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
438: hr_utility.set_message_token('PROCEDURE', l_proc);
439: hr_utility.set_message_token('STEP', '20');
440: end if;
441: --

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

434: if not pe_aei_shd.api_updating
435: (p_assignment_extra_info_id => p_rec.assignment_extra_info_id
436: ,p_object_version_number => p_rec.object_version_number) then
437: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
438: hr_utility.set_message_token('PROCEDURE', l_proc);
439: hr_utility.set_message_token('STEP', '20');
440: end if;
441: --
442: hr_utility.set_location(l_proc, 30);

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

435: (p_assignment_extra_info_id => p_rec.assignment_extra_info_id
436: ,p_object_version_number => p_rec.object_version_number) then
437: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
438: hr_utility.set_message_token('PROCEDURE', l_proc);
439: hr_utility.set_message_token('STEP', '20');
440: end if;
441: --
442: hr_utility.set_location(l_proc, 30);
443: --

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

438: hr_utility.set_message_token('PROCEDURE', l_proc);
439: hr_utility.set_message_token('STEP', '20');
440: end if;
441: --
442: hr_utility.set_location(l_proc, 30);
443: --
444: if nvl(p_rec.information_type, hr_api.g_varchar2) <>
445: nvl(pe_aei_shd.g_old_rec.information_type, hr_api.g_varchar2) then
446: l_argument := 'information_type';

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

446: l_argument := 'information_type';
447: raise l_error;
448: end if;
449: --
450: hr_utility.set_location(l_proc, 40);
451: --
452: if nvl(p_rec.assignment_id, hr_api.g_number) <>
453: nvl(pe_aei_shd.g_old_rec.assignment_id, hr_api.g_number) then
454: l_argument := 'assignment_id';

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

454: l_argument := 'assignment_id';
455: raise l_error;
456: end if;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 50);
459: exception
460: when l_error then
461: hr_api.argument_changed_error
462: (p_api_name => l_proc

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

461: hr_api.argument_changed_error
462: (p_api_name => l_proc
463: ,p_argument => l_argument
464: );
465: hr_utility.set_location(l_proc, 60);
466: when others then
467: hr_utility.set_location(l_proc, 70);
468: raise;
469: end chk_non_updateable_args;

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

463: ,p_argument => l_argument
464: );
465: hr_utility.set_location(l_proc, 60);
466: when others then
467: hr_utility.set_location(l_proc, 70);
468: raise;
469: end chk_non_updateable_args;
470: --
471: -- -----------------------------------------------------------------------

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

503: --
504: l_proc varchar2(72) := g_package||'chk_df';
505: --
506: begin
507: hr_utility.set_location('Entering:'||l_proc, 10);
508: --
509: if ((p_rec.assignment_extra_info_id is not null) and (
510: nvl(pe_aei_shd.g_old_rec.aei_attribute_category, hr_api.g_varchar2) <>
511: nvl(p_rec.aei_attribute_category, hr_api.g_varchar2) or

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

602: ,p_attribute20_name => 'AEI_ATTRIBUTE20'
603: ,p_attribute20_value => p_rec.aei_attribute20);
604: end if;
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 20);
607: end chk_df;
608: --
609: -- -----------------------------------------------------------------------
610: -- |------------------------------< chk_ddf >----------------------------|

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

643: l_proc varchar2(72) := g_package||'chk_ddf';
644: l_error exception;
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Check if the row is being inserted or updated and a
650: -- value has changed
651: --

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

783: );
784: --
785: end if;
786: --
787: hr_utility.set_location(' Leaving:'||l_proc, 10);
788: end chk_ddf;
789: --
790: -- ----------------------------------------------------------------------------
791: -- |---------------------------< insert_validate >----------------------------|

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

794: --
795: l_proc varchar2(72) := g_package||'insert_validate';
796: --
797: Begin
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: per_asg_bus1.set_security_group_id
801: (
802: p_assignment_id => p_rec.assignment_id

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

801: (
802: p_assignment_id => p_rec.assignment_id
803: );
804: --
805: hr_utility.set_location('Entering:'||l_proc, 7);
806: --
807: -- Validate Assignment Info Type
808: --
809: chk_assignment_info_type

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

822: );
823: --
824: if pe_aei_shd.g_called_from_form = FALSE then
825: --
826: hr_utility.set_location(l_proc, 10);
827: --
828: -- Call ddf procedure to validation Developer Descriptive Flexfields
829: --
830: pe_aei_bus.chk_ddf(p_rec => p_rec);

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

832: -- Call df procedure to validation Descriptive Flexfields
833: --
834: pe_aei_bus.chk_df(p_rec => p_rec);
835: --
836: hr_utility.set_location(l_proc, 15);
837: end if;
838: --
839: hr_utility.set_location(' Leaving:'||l_proc, 20);
840: --

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

835: --
836: hr_utility.set_location(l_proc, 15);
837: end if;
838: --
839: hr_utility.set_location(' Leaving:'||l_proc, 20);
840: --
841: End insert_validate;
842: --
843: -- ----------------------------------------------------------------------------

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

847: --
848: l_proc varchar2(72) := g_package||'update_validate';
849: --
850: Begin
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: per_asg_bus1.set_security_group_id
854: (
855: p_assignment_id => p_rec.assignment_id

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

854: (
855: p_assignment_id => p_rec.assignment_id
856: );
857: --
858: hr_utility.set_location('Entering:'||l_proc, 7);
859: -- Validate Non-Updateable Fields
860: --
861: chk_non_updateable_args (p_rec => p_rec);
862: --

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

859: -- Validate Non-Updateable Fields
860: --
861: chk_non_updateable_args (p_rec => p_rec);
862: --
863: hr_utility.set_location(l_proc, 15);
864: --
865: if pe_aei_shd.g_called_from_form = FALSE then
866: --
867: hr_utility.set_location(l_proc, 20);

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

863: hr_utility.set_location(l_proc, 15);
864: --
865: if pe_aei_shd.g_called_from_form = FALSE then
866: --
867: hr_utility.set_location(l_proc, 20);
868: --
869: -- Call ddf procedure to validate Developer Descriptive Flexfields
870: --
871: pe_aei_bus.chk_ddf(p_rec => p_rec);

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

873: -- Call df procedure to validate Descriptive Flexfields
874: --
875: pe_aei_bus.chk_df(p_rec => p_rec);
876: --
877: hr_utility.set_location(l_proc, 25);
878: --
879: end if;
880: --
881: hr_utility.set_location(' Leaving:'||l_proc, 30);

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

877: hr_utility.set_location(l_proc, 25);
878: --
879: end if;
880: --
881: hr_utility.set_location(' Leaving:'||l_proc, 30);
882: --
883: End update_validate;
884: --
885: -- ----------------------------------------------------------------------------

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

889: --
890: l_proc varchar2(72) := g_package||'delete_validate';
891: --
892: Begin
893: hr_utility.set_location('Entering:'||l_proc, 5);
894: --
895: -- Call all supporting business operations
896: --
897: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

893: hr_utility.set_location('Entering:'||l_proc, 5);
894: --
895: -- Call all supporting business operations
896: --
897: hr_utility.set_location(' Leaving:'||l_proc, 10);
898: --
899: End delete_validate;
900: --
901: end pe_aei_bus;