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

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

62: and p_effective_date between per.effective_start_date
63: and per.effective_end_date;
64: --
65: begin
66: hr_utility.set_location('Entering:'||l_proc,5);
67: --
68: -- Perform PERSON_ID mandatory check
69: --
70: hr_api.mandatory_arg_error

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

78: ,p_argument => 'effective date'
79: ,p_argument_value => p_effective_date
80: );
81: --
82: hr_utility.set_location(l_proc,10);
83: --
84: -- Check for valid PERSON_ID
85: --
86: open csr_valid_person_id;

Line 93: hr_utility.set_message(800,'PER_52092_PEA_INV_PERSON_ID');

89: if (csr_valid_person_id%notfound) then
90: --
91: close csr_valid_person_id;
92: --
93: hr_utility.set_message(800,'PER_52092_PEA_INV_PERSON_ID');
94: hr_utility.raise_error;
95: end if;
96: --
97: close csr_valid_person_id;

Line 94: hr_utility.raise_error;

90: --
91: close csr_valid_person_id;
92: --
93: hr_utility.set_message(800,'PER_52092_PEA_INV_PERSON_ID');
94: hr_utility.raise_error;
95: end if;
96: --
97: close csr_valid_person_id;
98: --

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

95: end if;
96: --
97: close csr_valid_person_id;
98: --
99: hr_utility.set_location(l_proc,15);
100: --
101: -- Check BUSINESS_GROUP_ID is in the same business group as the person
102: --
103: if (p_business_group_id <> l_business_group_id) then

Line 104: hr_utility.set_message(800,'PER_52090_PEA_INV_PERSON_COMB');

100: --
101: -- Check BUSINESS_GROUP_ID is in the same business group as the person
102: --
103: if (p_business_group_id <> l_business_group_id) then
104: hr_utility.set_message(800,'PER_52090_PEA_INV_PERSON_COMB');
105: hr_utility.raise_error;
106: end if;
107: --
108: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 105: hr_utility.raise_error;

101: -- Check BUSINESS_GROUP_ID is in the same business group as the person
102: --
103: if (p_business_group_id <> l_business_group_id) then
104: hr_utility.set_message(800,'PER_52090_PEA_INV_PERSON_COMB');
105: hr_utility.raise_error;
106: end if;
107: --
108: hr_utility.set_location('Leaving:'|| l_proc, 20);
109: exception

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

104: hr_utility.set_message(800,'PER_52090_PEA_INV_PERSON_COMB');
105: hr_utility.raise_error;
106: end if;
107: --
108: hr_utility.set_location('Leaving:'|| l_proc, 20);
109: exception
110: when app_exception.application_exception then
111: if hr_multi_message.exception_add
112: (p_associated_column1 => 'PER_PERSON_ANALYSES.PERSON_ID'

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

110: when app_exception.application_exception then
111: if hr_multi_message.exception_add
112: (p_associated_column1 => 'PER_PERSON_ANALYSES.PERSON_ID'
113: ) then
114: hr_utility.set_location('Leaving:'||l_proc, 30);
115: raise;
116: end if;
117: hr_utility.set_location('Leaving:'||l_proc,40);
118: end chk_person_id;

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

113: ) then
114: hr_utility.set_location('Leaving:'||l_proc, 30);
115: raise;
116: end if;
117: hr_utility.set_location('Leaving:'||l_proc,40);
118: end chk_person_id;
119: --
120: -- ----------------------------------------------------------------------------
121: -- |--------------------< chk_id_flex_num >-----------------------------------|

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

150: --
151: l_proc varchar2(72) := g_package||'chk_id_flex_num';
152: --
153: begin
154: hr_utility.set_location('Entering:'||l_proc,5);
155: --
156: -- Perform id_flex_num mandatory check
157: --
158: hr_api.mandatory_arg_error

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

160: ,p_argument => 'id_flex_num'
161: ,p_argument_value => p_id_flex_num
162: );
163: --
164: hr_utility.set_location('Leaving:'||l_proc, 10);
165: end chk_id_flex_num;
166: --
167: -- ----------------------------------------------------------------------------
168: -- |-----------------------< chk_analysis_criteria_id >-----------------------|

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

218: from per_analysis_criteria pac
219: where pac.analysis_criteria_id = p_analysis_criteria_id;
220: --
221: begin
222: hr_utility.set_location('Entering:'||l_proc,5);
223: --
224: -- Perform ANALYSIS_CRITERIA_ID mandatory check
225: --
226: hr_api.mandatory_arg_error

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

228: ,p_argument => 'analysis_criteria_id'
229: ,p_argument_value => p_analysis_criteria_id
230: );
231: --
232: hr_utility.set_location(l_proc,10);
233: --
234: l_api_updating := per_pea_shd.api_updating
235: (p_person_analysis_id => p_person_analysis_id
236: ,p_object_version_number => p_object_version_number);

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

244: (per_pea_shd.g_old_rec.id_flex_num <> p_id_flex_num))
245: or
246: (NOT l_api_updating)) then
247: --
248: hr_utility.set_location(l_proc,15);
249: --
250: open csr_valid_analysis_criteria_id;
251: fetch csr_valid_analysis_criteria_id
252: into l_id_flex_num;

Line 257: hr_utility.set_message(801,'HR_51603_PEA_INV_ANA_CRI_ID');

253: --
254: if (csr_valid_analysis_criteria_id%notfound) then
255: close csr_valid_analysis_criteria_id;
256: --
257: hr_utility.set_message(801,'HR_51603_PEA_INV_ANA_CRI_ID');
258: hr_multi_message.add
259: (p_associated_column1 => 'PER_PERSON_ANALYSES.ANALYSIS_CRITERIA_ID'
260: );
261: else

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

260: );
261: else
262: close csr_valid_analysis_criteria_id;
263: --
264: hr_utility.set_location(l_proc,20);
265: --
266: -- Check ID_FLEX_NUM is in the same ID_FLEX_NUM as the ANALYSIS_CRITERIA_ID
267: --
268: if (p_id_flex_num <> l_id_flex_num) then

Line 269: hr_utility.set_message(800,'PER_52093_PEA_INV_FLEX_ANA_COM');

265: --
266: -- Check ID_FLEX_NUM is in the same ID_FLEX_NUM as the ANALYSIS_CRITERIA_ID
267: --
268: if (p_id_flex_num <> l_id_flex_num) then
269: hr_utility.set_message(800,'PER_52093_PEA_INV_FLEX_ANA_COM');
270: hr_multi_message.add
271: (p_associated_column1 => 'PER_PERSON_ANALYSES.ANALYSIS_CRITERIA_ID'
272: ,p_associated_column2 => 'PER_PERSON_ANALYSES.ID_FLEX_NUM'
273: );

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

275: --
276: end if;
277: end if;
278: --
279: hr_utility.set_location('Leaving '||l_proc,25);
280: end chk_analysis_criteria_id;
281: --
282: -- ---------------------------------------------------------------------------
283: -- |------------------< check_for_duplicates >-----------------------------|

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

343: l_exists varchar2(1);
344: l_proc varchar2(72) := g_package||'check_for_duplicates';
345: --
346: begin
347: hr_utility.set_location('Entering:'||l_proc,5);
348: --
349: -- Only proceed with validation when multiple message list does not already
350: -- contain an error associated with ANALYSIS_CRITERIA_ID,DATE_FROM, DATE_TO
351: -- PERSON_ID columns.

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

368: ,p_argument => 'analysis_criteria_id'
369: ,p_argument_value => p_analysis_criteria_id
370: );
371: --
372: hr_utility.set_location(l_proc,10);
373: --
374: open c;
375: fetch c into l_exists;
376: if c%found then

Line 378: hr_utility.set_message(801,'HR_6012_ROW_INSERTED');

374: open c;
375: fetch c into l_exists;
376: if c%found then
377: close c;
378: hr_utility.set_message(801,'HR_6012_ROW_INSERTED');
379: hr_utility.raise_error;
380: end if;
381: close c;
382: end if;

Line 379: hr_utility.raise_error;

375: fetch c into l_exists;
376: if c%found then
377: close c;
378: hr_utility.set_message(801,'HR_6012_ROW_INSERTED');
379: hr_utility.raise_error;
380: end if;
381: close c;
382: end if;
383: hr_utility.set_location('Leaving '||l_proc,15);

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

379: hr_utility.raise_error;
380: end if;
381: close c;
382: end if;
383: hr_utility.set_location('Leaving '||l_proc,15);
384: exception
385: --
386: -- When multiple error detection is enabled handle the application errors
387: -- which have been raised by this procedure.

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

389: when app_exception.application_exception then
390: if hr_multi_message.exception_add
391: (p_same_associated_columns => 'Y'
392: ) then
393: hr_utility.set_location('Leaving:'||l_proc, 30);
394: raise;
395: end if;
396: hr_utility.set_location('Leaving:'||l_proc,40);
397: end check_for_duplicates;

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

392: ) then
393: hr_utility.set_location('Leaving:'||l_proc, 30);
394: raise;
395: end if;
396: hr_utility.set_location('Leaving:'||l_proc,40);
397: end check_for_duplicates;
398: --
399: --
400: -- ---------------------------------------------------------------------------

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

440: l_proc varchar2(72) := g_package||'chk_date_from_to';
441: l_api_updating boolean;
442: --
443: begin
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: -- Only proceed with validation if :
447: -- a) The current g_old_rec is current and
448: -- b) The DATE_TO value has changed

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

460: (NOT l_api_updating))) then
461: --
462: -- Check DATE_FROM.If the DATE_TO has value,DATE_FROM is not null.
463: --
464: hr_utility.set_location(l_proc,10);
465: --
466: if p_date_to is not null and p_date_from is null then
467: --
468: hr_utility.set_message(800,'PER_52095_PEA_INV_DATE_FROM');

Line 468: hr_utility.set_message(800,'PER_52095_PEA_INV_DATE_FROM');

464: hr_utility.set_location(l_proc,10);
465: --
466: if p_date_to is not null and p_date_from is null then
467: --
468: hr_utility.set_message(800,'PER_52095_PEA_INV_DATE_FROM');
469: hr_multi_message.add
470: (p_associated_column1 => 'PER_PERSON_ANALYSES.DATE_FROM'
471: ,p_associated_column2 => 'PER_PERSON_ANALYSES.DATE_TO'
472: );

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

474: elsif p_date_from is not null then
475: --
476: -- Check that DATE_FROM <= DATE_TO
477: --
478: hr_utility.set_location(l_proc,15);
479: --
480: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
481: --
482: hr_utility.set_message(800,'PER_52094_PEA_INV_DATE_COMB');

Line 482: hr_utility.set_message(800,'PER_52094_PEA_INV_DATE_COMB');

478: hr_utility.set_location(l_proc,15);
479: --
480: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
481: --
482: hr_utility.set_message(800,'PER_52094_PEA_INV_DATE_COMB');
483: hr_multi_message.add
484: (p_associated_column1 => 'PER_PERSON_ANALYSES.DATE_FROM'
485: ,p_associated_column2 => 'PER_PERSON_ANALYSES.DATE_TO'
486: );

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

489: end if;
490: --
491: end if;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc,20);
494: --
495: end chk_date_from_to;
496: --
497: -- ----------------------------------------------------------------------------

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

502: --
503: l_proc varchar2(72) := g_package||'check_non_updateable_args';
504: --
505: Begin
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Only proceed with validation if a row exists for
509: -- the current record in the HR Schema
510: --

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

511: if not per_pea_shd.api_updating
512: (p_person_analysis_id => p_rec.person_analysis_id
513: ,p_object_version_number => p_rec.object_version_number
514: ) then
515: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('PROCEDURE', l_proc);
517: hr_utility.set_message_token('STEP', '5');
518: hr_utility.raise_error;
519: end if;

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

512: (p_person_analysis_id => p_rec.person_analysis_id
513: ,p_object_version_number => p_rec.object_version_number
514: ) then
515: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('PROCEDURE', l_proc);
517: hr_utility.set_message_token('STEP', '5');
518: hr_utility.raise_error;
519: end if;
520: --

Line 517: hr_utility.set_message_token('STEP', '5');

513: ,p_object_version_number => p_rec.object_version_number
514: ) then
515: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('PROCEDURE', l_proc);
517: hr_utility.set_message_token('STEP', '5');
518: hr_utility.raise_error;
519: end if;
520: --
521: hr_utility.set_location(l_proc,10);

Line 518: hr_utility.raise_error;

514: ) then
515: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('PROCEDURE', l_proc);
517: hr_utility.set_message_token('STEP', '5');
518: hr_utility.raise_error;
519: end if;
520: --
521: hr_utility.set_location(l_proc,10);
522: --

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

517: hr_utility.set_message_token('STEP', '5');
518: hr_utility.raise_error;
519: end if;
520: --
521: hr_utility.set_location(l_proc,10);
522: --
523: --
524: if nvl(p_rec.business_group_id, hr_api.g_number) <>
525: per_pea_shd.g_old_rec.business_group_id then

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

537: ,p_argument => 'PERSON_ID'
538: ,p_base_table => per_pea_shd.g_tab_nam
539: );
540: end if;
541: hr_utility.set_location(' Leaving:'||l_proc, 15);
542: end check_non_updateable_args;
543: --
544: -- -----------------------------------------------------------------------
545: -- |------------------------------< chk_df >-----------------------------|

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

573: --
574: l_proc varchar2(72) := g_package||'chk_df';
575: --
576: begin
577: hr_utility.set_location('Entering:'||l_proc, 10);
578: --
579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

673: ,p_attribute20_value => p_rec.attribute20
674: );
675: end if;
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 20);
678: end chk_df;
679: --
680: -- ----------------------------------------------------------------------------
681: -- |---------------------------< insert_validate >----------------------------|

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

686: --
687: l_proc varchar2(72) := g_package||'insert_validate';
688: --
689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: -- Validate Important Attributes
693: --
694: hr_api.validate_bus_grp_id

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

704: --
705: --validate dependent attributes
706: -- Call all supporting business operations
707: --
708: hr_utility.set_location(l_proc, 6);
709: --
710: -- Validate person id and business group id
711: --
712: chk_person_id

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

714: p_business_group_id => p_rec.business_group_id,
715: p_effective_date => p_effective_date
716: );
717: --
718: hr_utility.set_location(l_proc, 7);
719: --
720: -- Validate id flex num
721: --
722: chk_id_flex_num(p_id_flex_num => p_rec.id_flex_num);

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

720: -- Validate id flex num
721: --
722: chk_id_flex_num(p_id_flex_num => p_rec.id_flex_num);
723: --
724: hr_utility.set_location(l_proc, 8);
725: --
726: -- Validate analysis criteria id
727: --
728: chk_analysis_criteria_id

Line 735: hr_utility.set_location(l_proc, 9);

731: p_person_analysis_id => p_rec.person_analysis_id,
732: p_object_version_number => p_rec.object_version_number
733: );
734: --
735: hr_utility.set_location(l_proc, 9);
736: --
737: --
738: -- Validate date
739: --

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

743: p_date_to => p_rec.date_to,
744: p_object_version_number => p_rec.object_version_number
745: );
746: --
747: hr_utility.set_location(l_proc, 10);
748: --
749: -- Check For Duplicates
750: --
751: check_for_duplicates

Line 762: hr_utility.set_location(l_proc, 11);

758: ,p_person_analysis_id => p_rec.person_analysis_id
759: );
760: --
761: --
762: hr_utility.set_location(l_proc, 11);
763: --
764: ----
765: -- Validate flex fields.
766: --

Line 769: hr_utility.set_location('Leaving:'||l_proc, 12);

765: -- Validate flex fields.
766: --
767: chk_df(p_rec => p_rec);
768: --
769: hr_utility.set_location('Leaving:'||l_proc, 12);
770: --
771:
772: End insert_validate;
773: --

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

779: --
780: l_proc varchar2(72) := g_package||'update_validate';
781: --
782: Begin
783: hr_utility.set_location('Entering:'||l_proc, 5);
784: --
785: -- Validate Important Attributes
786: --
787: hr_api.validate_bus_grp_id

Line 801: hr_utility.set_location(l_proc, 6);

797: --
798: -- validate dependent attributes
799: -- Call all supporting business operations
800: --
801: hr_utility.set_location(l_proc, 6);
802: --
803: -- Check the non-updateable arguments have in fact not been modified
804: --
805: per_pea_bus.check_non_updateable_args(p_rec => p_rec);

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

803: -- Check the non-updateable arguments have in fact not been modified
804: --
805: per_pea_bus.check_non_updateable_args(p_rec => p_rec);
806: --
807: hr_utility.set_location(l_proc, 7);
808: --
809: -- Validate id flex num
810: --
811: chk_id_flex_num(p_id_flex_num => p_rec.id_flex_num);

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

809: -- Validate id flex num
810: --
811: chk_id_flex_num(p_id_flex_num => p_rec.id_flex_num);
812: --
813: hr_utility.set_location(l_proc, 8);
814: --
815: -- Validate analysis criteria id
816: --
817: chk_analysis_criteria_id

Line 824: hr_utility.set_location(l_proc, 9);

820: p_person_analysis_id => p_rec.person_analysis_id,
821: p_object_version_number => p_rec.object_version_number
822: );
823: --
824: hr_utility.set_location(l_proc, 9);
825: --
826: --
827: -- Validate date
828: --

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

833: p_object_version_number => p_rec.object_version_number
834: );
835: --
836: --
837: hr_utility.set_location(l_proc, 10);
838: --
839: -- Check For Duplicates
840: --
841: check_for_duplicates

Line 852: hr_utility.set_location(l_proc, 11);

848: ,p_person_analysis_id => p_rec.person_analysis_id
849: );
850: --
851: --
852: hr_utility.set_location(l_proc, 11);
853: --
854: ----
855: -- Validate flex fields.
856: --

Line 859: hr_utility.set_location('Leaving:'||l_proc, 12);

855: -- Validate flex fields.
856: --
857: chk_df(p_rec => p_rec);
858: --
859: hr_utility.set_location('Leaving:'||l_proc, 12);
860: --
861: End update_validate;
862: --
863: -- ----------------------------------------------------------------------------

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

867: --
868: l_proc varchar2(72) := g_package||'delete_validate';
869: --
870: Begin
871: hr_utility.set_location('Entering:'||l_proc, 5);
872: --
873: -- Call all supporting business operations
874: --
875: --

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

876: -- Validate flex fields.
877: --
878: chk_df(p_rec => p_rec);
879: --
880: hr_utility.set_location(' Leaving:'||l_proc, 10);
881: End delete_validate;
882: --
883: --
884: -- ----------------------------------------------------------------------------

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

902: l_proc varchar2(72) := 'return_legislation_code';
903: l_legislation_code varchar2(150);
904: --
905: begin
906: hr_utility.set_location('Entering:'||l_proc, 10);
907: --
908: -- Ensure that all the mandatory parameters are not null
909: --
910: hr_api.mandatory_arg_error (p_api_name => l_proc,

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

916: -- call to this function. Just return the value in the global
917: -- variable.
918: --
919: l_legislation_code := g_legislation_code;
920: hr_utility.set_location(l_proc, 20);
921: else
922: --
923: -- The ID is different to the last call to this function
924: -- or this is the first call to this function.

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

933: --
934: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
935: fnd_message.raise_error;
936: end if;
937: hr_utility.set_location(l_proc, 30);
938: --
939: -- Set the global variables so the values are
940: -- available for the next call to this function
941: --

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

942: close csr_leg_code;
943: g_person_analysis_id := p_person_analysis_id;
944: g_legislation_code := l_legislation_code;
945: end if;
946: hr_utility.set_location(' Leaving:'||l_proc, 40);
947: return l_legislation_code;
948: --
949: end return_legislation_code;
950: --