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

Line 73: hr_utility.set_location('Entering:'|| l_proc, 12);

69: and hoi.org_information1='REPBODY'
70: and hoi.org_information2='Y');
71: --
72: begin
73: hr_utility.set_location('Entering:'|| l_proc, 12);
74: --
75: -- Check mandatory parameters have been set
76: --
77: hr_api.mandatory_arg_error

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

79: ,p_argument => 'rep_body_id'
80: ,p_argument_value => p_rep_body_id
81: );
82: --
83: hr_utility.set_location(l_proc, 20);
84: --
85: -- Check if inserting or updating with modified values
86: --
87: l_api_updating := per_elc_shd.api_updating

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

93: if ((l_api_updating and per_elc_shd.g_old_rec.rep_body_id <> p_rep_body_id)
94: or
95: (NOT l_api_updating))
96: then
97: hr_utility.set_location(l_proc, 30);
98: --
99: -- Check that the Representative Body ID is linked to a
100: -- valid representative on hr_all_organiztion_units
101: --

Line 108: hr_utility.raise_error;

104: if csr_valid_rep_body%notfound then
105: --
106: close csr_valid_rep_body;
107: fnd_message.set_name('PER', 'PER_289097_ELC_NO_REP_BODY');
108: hr_utility.raise_error;
109: --
110: end if;
111: close csr_valid_rep_body;
112: end if;

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

110: end if;
111: close csr_valid_rep_body;
112: end if;
113: --
114: hr_utility.set_location(' Leaving:'|| l_proc, 40);
115: end chk_rep_body_id;
116: --
117: -- ---------------------------------------------------------------------------
118: -- |---------------------------< chk_can_delete >---------------------------|

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

159: from per_election_constituencys con
160: where con.election_id = p_election_id;
161: --
162: begin
163: hr_utility.set_location(l_proc, 20);
164: --
165: -- Check if inserting or updating with modified values
166: --
167: l_api_updating := per_elc_shd.api_updating

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

173: -- if ((l_api_updating and per_elc_shd.g_old_rec.election_id <> p_election_id)
174: -- or
175: -- (NOT l_api_updating))
176: -- then
177: hr_utility.set_location(l_proc, 30);
178: --
179: -- Check that the Election ID is not linked to a
180: -- valid candidate on per_election_candidates
181: --

Line 188: hr_utility.raise_error;

184: if csr_valid_can_exists%found then
185: --
186: close csr_valid_can_exists;
187: fnd_message.set_name('PER', 'PER_289107_ELC_ID_CAN_EXISTS');
188: hr_utility.raise_error;
189: --
190: end if;
191: close csr_valid_can_exists;
192: --

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

189: --
190: end if;
191: close csr_valid_can_exists;
192: --
193: hr_utility.set_location(l_proc, 40);
194: --
195: -- Check that the Election ID is not linked to a
196: -- valid candidate on per_election_constituencies
197: --

Line 204: hr_utility.raise_error;

200: if csr_valid_con_exists%found then
201: --
202: close csr_valid_con_exists;
203: fnd_message.set_name('PER', 'PER_289108_ELC_ID_CON_EXISTS');
204: hr_utility.raise_error;
205: --
206: end if;
207: close csr_valid_con_exists;
208: --

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

207: close csr_valid_con_exists;
208: --
209: -- end if;
210: --
211: hr_utility.set_location(' Leaving:'|| l_proc, 40);
212: end chk_can_delete;
213: --
214: -- ---------------------------------------------------------------------------
215: -- |-------------------------< chk_election_date >--------------------------|

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

248: --
249: -- Cursor for text compare. From hr_organization_information
250: --
251: begin
252: hr_utility.set_location('Entering:'|| l_proc, 10);
253: --
254: -- Check mandatory parameters have been set
255: --
256: hr_api.mandatory_arg_error

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

259: ,p_argument_value => p_election_date
260: );
261: --
262:
263: hr_utility.set_location(l_proc, 20);
264: --
265: -- Check if inserting or updating with modified values
266: --
267: l_api_updating := per_elc_shd.api_updating

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

272: if ((l_api_updating and per_elc_shd.g_old_rec.election_date <> p_election_date)
273: or
274: (NOT l_api_updating))
275: then
276: hr_utility.set_location(l_proc, 30);
277: --
278: -- Check that the date_from values is less than
279: -- or equal to the date_to value for the current
280: -- record

Line 284: hr_utility.raise_error;

280: -- record
281: --
282: if p_election_date > nvl(p_result_publish_date, hr_api.g_eot) then
283: fnd_message.set_name('PER', 'PER_289098_ELC_DATE_ERROR');
284: hr_utility.raise_error;
285: end if;
286: --
287: end if;
288: --

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

286: --
287: end if;
288: --
289: --
290: hr_utility.set_location(' Leaving:'|| l_proc, 40);
291: end chk_election_date;
292: --
293: -- ---------------------------------------------------------------------------
294: -- |----------------------< set_security_group_id >--------------------------|

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

313: l_proc varchar2(72) := g_package||'set_security_group_id';
314: --
315: begin
316: --
317: hr_utility.set_location('Entering:'|| l_proc, 10);
318: --
319: -- Ensure that all the mandatory parameter are not null
320: --
321: hr_api.mandatory_arg_error

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

344: hr_api.set_security_group_id
345: (p_security_group_id => l_security_group_id
346: );
347: --
348: hr_utility.set_location(' Leaving:'|| l_proc, 20);
349: --
350: end set_security_group_id;
351: --
352: -- ---------------------------------------------------------------------------

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

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

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

391: -- call to this function. Just return the value in the global
392: -- variable.
393: --
394: l_legislation_code := per_elc_bus.g_legislation_code;
395: hr_utility.set_location(l_proc, 20);
396: else
397: --
398: -- The ID is different to the last call to this function
399: -- or this is the first call to this function.

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

408: close csr_leg_code;
409: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
410: fnd_message.raise_error;
411: end if;
412: hr_utility.set_location(l_proc,30);
413: --
414: -- Set the global variables so the values are
415: -- available for the next call to this function.
416: --

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

417: close csr_leg_code;
418: per_elc_bus.g_election_id := p_election_id;
419: per_elc_bus.g_legislation_code := l_legislation_code;
420: end if;
421: hr_utility.set_location(' Leaving:'|| l_proc, 40);
422: return l_legislation_code;
423: end return_legislation_code;
424: --
425: -- ----------------------------------------------------------------------------

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

456: --
457: l_proc varchar2(72) := g_package || 'chk_ddf';
458: --
459: begin
460: hr_utility.set_location('Entering:'||l_proc,10);
461: --
462: if ((p_rec.election_id is not null) and (
463: nvl(per_elc_shd.g_old_rec.election_info_category, hr_api.g_varchar2) <>
464: nvl(p_rec.election_info_category, hr_api.g_varchar2) or

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

595: ,p_attribute30_value => p_rec.election_information30
596: );
597: end if;
598: --
599: hr_utility.set_location(' Leaving:'||l_proc,20);
600: end chk_ddf;
601: --
602: -- ----------------------------------------------------------------------------
603: -- |------------------------------< chk_df >----------------------------------|

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

633: --
634: l_proc varchar2(72) := g_package || 'chk_df';
635: --
636: begin
637: hr_utility.set_location('Entering:'||l_proc,10);
638: --
639: if ((p_rec.election_id is not null) and (
640: nvl(per_elc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
641: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

772: ,p_attribute30_value => p_rec.attribute30
773: );
774: end if;
775: --
776: hr_utility.set_location(' Leaving:'||l_proc,20);
777: end chk_df;
778: --
779: -- ----------------------------------------------------------------------------
780: -- |-----------------------< chk_non_updateable_args >------------------------|

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

849: --
850: l_proc varchar2(72) := g_package||'insert_validate';
851: --
852: Begin
853: hr_utility.set_location('Entering:'||l_proc, 5);
854: --
855: -- Call all supporting business operations
856: --
857: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 860: hr_utility.set_location('Entering: chk_rep_body_id', 10);

856: --
857: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
858: --
859: --
860: hr_utility.set_location('Entering: chk_rep_body_id', 10);
861:
862: chk_rep_body_id
863: (p_election_id => p_rec.election_id
864: ,p_rep_body_id => p_rec.rep_body_id

Line 868: hr_utility.set_location('Entering: chk_election_date', 15);

864: ,p_rep_body_id => p_rec.rep_body_id
865: ,p_object_version_number => p_rec.object_version_number
866: );
867:
868: hr_utility.set_location('Entering: chk_election_date', 15);
869:
870: chk_election_date
871: (p_election_id => p_rec.election_id
872: ,p_election_date => p_rec.election_date

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

877: per_elc_bus.chk_ddf(p_rec);
878: --
879: per_elc_bus.chk_df(p_rec);
880: --
881: hr_utility.set_location(' Leaving:'||l_proc, 20);
882: End insert_validate;
883: --
884: -- ----------------------------------------------------------------------------
885: -- |---------------------------< update_validate >----------------------------|

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

891: --
892: l_proc varchar2(72) := g_package||'update_validate';
893: --
894: Begin
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: -- Call all supporting business operations
898: --
899: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

902: (p_effective_date => p_effective_date
903: ,p_rec => p_rec
904: );
905: --
906: hr_utility.set_location('Entering: chk_rep_body_id', 10);
907:
908: chk_rep_body_id
909: (p_election_id => p_rec.election_id
910: ,p_rep_body_id => p_rec.rep_body_id

Line 914: hr_utility.set_location('Entering: chk_election_date', 15);

910: ,p_rep_body_id => p_rec.rep_body_id
911: ,p_object_version_number => p_rec.object_version_number
912: );
913:
914: hr_utility.set_location('Entering: chk_election_date', 15);
915:
916: chk_election_date
917: (p_election_id => p_rec.election_id
918: ,p_election_date => p_rec.election_date

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

924: per_elc_bus.chk_ddf(p_rec);
925: --
926: per_elc_bus.chk_df(p_rec);
927: --
928: hr_utility.set_location(' Leaving:'||l_proc, 20);
929: End update_validate;
930: --
931: -- ----------------------------------------------------------------------------
932: -- |---------------------------< delete_validate >----------------------------|

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

937: --
938: l_proc varchar2(72) := g_package||'delete_validate';
939: --
940: Begin
941: hr_utility.set_location('Entering:'||l_proc, 5);
942: --
943: -- Call all supporting business operations
944: --
945: per_elc_bus.chk_can_delete

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

946: (p_election_id => p_rec.election_id
947: ,p_object_version_number => p_rec.object_version_number
948: );
949: --
950: hr_utility.set_location(' Leaving:'||l_proc, 20);
951: End delete_validate;
952: --
953: end per_elc_bus;