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

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

58: from per_elections pe
59: where pe.election_id = p_election_id;
60:
61: begin
62: hr_utility.set_location('Entering:'|| l_proc, 10);
63: --
64: -- Check mandatory parameters have been set
65: --
66: hr_api.mandatory_arg_error

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

68: ,p_argument => 'election_id'
69: ,p_argument_value => p_election_id
70: );
71: --
72: hr_utility.set_location(l_proc, 20);
73: --
74: -- Check if inserting or updating with modified values
75: --
76: l_api_updating := per_eco_shd.api_updating

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

81: if ((l_api_updating and per_eco_shd.g_old_rec.election_id <> p_election_id)
82: or
83: (NOT l_api_updating))
84: then
85: hr_utility.set_location(l_proc, 30);
86: --
87: -- Check that the Election ID is linked to a
88: -- valid election_id on per_elections
89: --

Line 96: hr_utility.raise_error;

92: if csr_valid_election_id%notfound then
93: --
94: close csr_valid_election_id;
95: fnd_message.set_name('PER', 'PER_289099_ECO_ELEC_ID_INVALID');
96: hr_utility.raise_error;
97: --
98: else
99: close csr_valid_election_id;
100:

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

100:
101: end if;
102: end if;
103: --
104: hr_utility.set_location(' Leaving:'|| l_proc, 40);
105: end chk_election_id;
106: --
107: -- ---------------------------------------------------------------------------
108: -- |-------------------< chk_duplicate_constituency >-----------------------|

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

148: and constituency_id = p_constituency_id;
149: --
150: begin
151:
152: hr_utility.set_location('Entering:'|| l_proc, 10);
153: --
154: -- Check mandatory parameters have been set
155: --
156: hr_api.mandatory_arg_error

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

164: ,p_argument => 'constituency_id'
165: ,p_argument_value => p_constituency_id
166: );
167: --
168: hr_utility.set_location(l_proc, 20);
169: --
170: -- Check that the candidate has not been entered for this election before
171: --
172: open csr_valid_constituency;

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

174: if csr_valid_constituency%found then
175: --
176: if p_election_constituency_id is null or
177: p_election_constituency_id <> l_constituency_id then
178: hr_utility.set_location(l_proc, 30);
179: fnd_message.set_name('PER', 'HR_289258_ECO_DUP_CONSTITUENCY');
180: hr_utility.raise_error;
181: --
182: end if;

Line 180: hr_utility.raise_error;

176: if p_election_constituency_id is null or
177: p_election_constituency_id <> l_constituency_id then
178: hr_utility.set_location(l_proc, 30);
179: fnd_message.set_name('PER', 'HR_289258_ECO_DUP_CONSTITUENCY');
180: hr_utility.raise_error;
181: --
182: end if;
183: end if;
184: --

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

183: end if;
184: --
185: close csr_valid_constituency;
186: --
187: hr_utility.set_location(' Leaving:'|| l_proc, 50);
188: end chk_duplicate_constituency;
189: --
190: -- ---------------------------------------------------------------------------
191: -- |---------------------------< chk_can_delete >---------------------------|

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

228: from per_election_candidates pec
229: where pec.election_id = p_election_id;
230: --
231: begin
232: hr_utility.set_location(l_proc, 20);
233: --
234: hr_utility.set_location(l_proc, 30);
235: --
236: -- Check that the Election ID is not linked to a

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

230: --
231: begin
232: hr_utility.set_location(l_proc, 20);
233: --
234: hr_utility.set_location(l_proc, 30);
235: --
236: -- Check that the Election ID is not linked to a
237: -- valid candidate on per_election_candidates
238: --

Line 245: hr_utility.raise_error;

241: if csr_valid_can_exists%found then
242: --
243: close csr_valid_can_exists;
244: fnd_message.set_name('PER', 'PER_289109_ECO_ID_CAN_EXISTS');
245: hr_utility.raise_error;
246: --
247: end if;
248: close csr_valid_can_exists;
249: --

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

246: --
247: end if;
248: close csr_valid_can_exists;
249: --
250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
251: end chk_can_delete;
252: --
253: -- ---------------------------------------------------------------------------
254: -- |------------------------< chk_constituency_id >-------------------------|

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

303: and hoi.org_information1='CONSTITUENCY'
304: and hoi.org_information2='Y');
305: --
306: begin
307: hr_utility.set_location('Entering:'|| l_proc, 10);
308: --
309: -- Check mandatory parameters have been set
310: --
311: hr_api.mandatory_arg_error

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

313: ,p_argument => 'constituency_id'
314: ,p_argument_value => p_constituency_id
315: );
316: --
317: hr_utility.set_location(l_proc, 20);
318: --
319: -- Check if inserting or updating with modified values
320: --
321: l_api_updating := per_eco_shd.api_updating

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

326: if ((l_api_updating and per_eco_shd.g_old_rec.constituency_id <> p_constituency_id)
327: or
328: (NOT l_api_updating))
329: then
330: hr_utility.set_location(l_proc, 30);
331: --
332: -- Check that the Constituency ID is linked to a
333: -- valid representative on hr_organiztion_information
334: --

Line 341: hr_utility.raise_error;

337: if csr_valid_const_id%notfound then
338: --
339: close csr_valid_const_id;
340: fnd_message.set_name('PER', 'PER_289100_ECO_CONST_INVALID');
341: hr_utility.raise_error;
342: --
343: end if;
344: --
345: close csr_valid_const_id;

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

344: --
345: close csr_valid_const_id;
346: end if;
347: --
348: hr_utility.set_location(' Leaving:'|| l_proc, 40);
349: end chk_constituency_id;
350: --
351: -- ---------------------------------------------------------------------------
352: -- |----------------------< set_security_group_id >--------------------------|

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

371: l_proc varchar2(72) := g_package||'set_security_group_id';
372: --
373: begin
374: --
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: --
377: -- Ensure that all the mandatory parameter are not null
378: --
379: hr_api.mandatory_arg_error

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

402: hr_api.set_security_group_id
403: (p_security_group_id => l_security_group_id
404: );
405: --
406: hr_utility.set_location(' Leaving:'|| l_proc, 20);
407: --
408: end set_security_group_id;
409: --
410: -- ---------------------------------------------------------------------------

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

431: l_proc varchar2(72) := g_package||'return_legislation_code';
432: --
433: Begin
434: --
435: hr_utility.set_location('Entering:'|| l_proc, 10);
436: --
437: -- Ensure that all the mandatory parameter are not null
438: --
439: hr_api.mandatory_arg_error

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

449: -- call to this function. Just return the value in the global
450: -- variable.
451: --
452: l_legislation_code := per_eco_bus.g_legislation_code;
453: hr_utility.set_location(l_proc, 20);
454: else
455: --
456: -- The ID is different to the last call to this function
457: -- or this is the first call to this function.

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

466: close csr_leg_code;
467: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
468: fnd_message.raise_error;
469: end if;
470: hr_utility.set_location(l_proc,30);
471: --
472: -- Set the global variables so the values are
473: -- available for the next call to this function.
474: --

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

475: close csr_leg_code;
476: per_eco_bus.g_election_constituency_id:= p_election_constituency_id;
477: per_eco_bus.g_legislation_code := l_legislation_code;
478: end if;
479: hr_utility.set_location(' Leaving:'|| l_proc, 40);
480: return l_legislation_code;
481: end return_legislation_code;
482: --
483: -- ----------------------------------------------------------------------------

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

514: --
515: l_proc varchar2(72) := g_package || 'chk_df';
516: --
517: begin
518: hr_utility.set_location('Entering:'||l_proc,10);
519: --
520: if ((p_rec.election_constituency_id is not null) and (
521: nvl(per_eco_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

653: ,p_attribute30_value => p_rec.attribute30
654: );
655: end if;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc,20);
658: end chk_df;
659: --
660: -- ----------------------------------------------------------------------------
661: -- |-----------------------< chk_non_updateable_args >------------------------|

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

730: --
731: l_proc varchar2(72) := g_package||'insert_validate';
732: --
733: Begin
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: --
736: -- Call all supporting business operations
737: --
738: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 740: hr_utility.set_location('Entering: chk_election_id',10);

736: -- Call all supporting business operations
737: --
738: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
739: --
740: hr_utility.set_location('Entering: chk_election_id',10);
741:
742: chk_election_id
743: (p_election_id => p_rec.election_id
744: ,p_election_constituency_id => p_rec.election_constituency_id

Line 748: hr_utility.set_location('Entering: chk_constituency_id', 15);

744: ,p_election_constituency_id => p_rec.election_constituency_id
745: ,p_object_version_number => p_rec.object_version_number
746: );
747:
748: hr_utility.set_location('Entering: chk_constituency_id', 15);
749:
750: chk_constituency_id
751: (p_constituency_id => p_rec.constituency_id
752: ,p_election_constituency_id => p_rec.election_constituency_id

Line 756: hr_utility.set_location('Entering: chk_duplicate_constituency', 15);

752: ,p_election_constituency_id => p_rec.election_constituency_id
753: ,p_object_version_number => p_rec.object_version_number
754: );
755:
756: hr_utility.set_location('Entering: chk_duplicate_constituency', 15);
757: chk_duplicate_constituency
758: (p_election_id => p_rec.election_id
759: ,p_constituency_id => p_rec.constituency_id
760: ,p_election_constituency_id => p_rec.election_constituency_id

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

762: --
763: --
764: per_eco_bus.chk_df(p_rec);
765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 20);
767: End insert_validate;
768: --
769: -- ----------------------------------------------------------------------------
770: -- |---------------------------< update_validate >----------------------------|

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

776: --
777: l_proc varchar2(72) := g_package||'update_validate';
778: --
779: Begin
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: -- Call all supporting business operations
783: --
784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 791: hr_utility.set_location('Entering: chk_election_id',10);

787: (p_effective_date => p_effective_date
788: ,p_rec => p_rec
789: );
790: --
791: hr_utility.set_location('Entering: chk_election_id',10);
792:
793: chk_election_id
794: (p_election_id => p_rec.election_id
795: ,p_election_constituency_id => p_rec.election_constituency_id

Line 799: hr_utility.set_location('Entering: chk_constituency_id', 15);

795: ,p_election_constituency_id => p_rec.election_constituency_id
796: ,p_object_version_number => p_rec.object_version_number
797: );
798:
799: hr_utility.set_location('Entering: chk_constituency_id', 15);
800:
801: chk_constituency_id
802: (p_constituency_id => p_rec.constituency_id
803: ,p_election_constituency_id => p_rec.election_constituency_id

Line 807: hr_utility.set_location('Entering: chk_duplicate_constituency', 15);

803: ,p_election_constituency_id => p_rec.election_constituency_id
804: ,p_object_version_number => p_rec.object_version_number
805: );
806:
807: hr_utility.set_location('Entering: chk_duplicate_constituency', 15);
808:
809: chk_duplicate_constituency
810: (p_election_id => p_rec.election_id
811: ,p_constituency_id => p_rec.constituency_id

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

813: );
814: --
815: per_eco_bus.chk_df(p_rec);
816: --
817: hr_utility.set_location(' Leaving:'||l_proc, 20);
818: End update_validate;
819: --
820: -- ----------------------------------------------------------------------------
821: -- |---------------------------< delete_validate >----------------------------|

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

826: --
827: l_proc varchar2(72) := g_package||'delete_validate';
828: --
829: Begin
830: hr_utility.set_location('Entering:'||l_proc, 5);
831: --
832: -- Call all supporting business operations
833: --
834: per_eco_bus.chk_can_delete

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

836: ,p_election_id => p_rec.election_id
837: ,p_object_version_number => p_rec.object_version_number
838: );
839: --
840: hr_utility.set_location(' Leaving:'||l_proc, 20);
841: End delete_validate;
842: --
843: end per_eco_bus;