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

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: 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, 10);

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

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

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

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

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

140: close csr_leg_code;
141: per_eca_bus.g_election_candidate_id:= p_election_candidate_id;
142: per_eca_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

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

247: where election_candidate_id = p_election_candidate_id
248: and role_id is null;
249: --
250: begin
251: hr_utility.set_location('Entering:'|| l_proc, 10);
252: --
253: -- Check mandatory parameters have been set
254: --
255: hr_api.mandatory_arg_error

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

257: ,p_argument => 'election_candidate_id'
258: ,p_argument_value => p_election_candidate_id
259: );
260: --
261: hr_utility.set_location(l_proc, 20);
262: --
263: open csr_valid_del;
264: fetch csr_valid_del into l_election_candidate_id;
265: if csr_valid_del%notfound then

Line 268: hr_utility.set_message(800,'PER_289105_ECA_CANNOT_BE_DELET');

264: fetch csr_valid_del into l_election_candidate_id;
265: if csr_valid_del%notfound then
266: --
267: close csr_valid_del;
268: hr_utility.set_message(800,'PER_289105_ECA_CANNOT_BE_DELET');
269: hr_utility.raise_error;
270: --
271: end if;
272: close csr_valid_del; --

Line 269: hr_utility.raise_error;

265: if csr_valid_del%notfound then
266: --
267: close csr_valid_del;
268: hr_utility.set_message(800,'PER_289105_ECA_CANNOT_BE_DELET');
269: hr_utility.raise_error;
270: --
271: end if;
272: close csr_valid_del; --
273: -- end if;

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

271: end if;
272: close csr_valid_del; --
273: -- end if;
274: --
275: hr_utility.set_location(' Leaving:'|| l_proc, 50);
276: end chk_delete;
277:
278: --
279: --

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

286: --
287: l_proc varchar2(72) := g_package||'delete_validate';
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- Call all supporting business operations
293: chk_delete(p_election_candidate_id => p_rec.election_candidate_id);
294:

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

292: -- Call all supporting business operations
293: chk_delete(p_election_candidate_id => p_rec.election_candidate_id);
294:
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: End delete_validate;
298: --
299: -- |---------------------------< chk_person_id >----------------------------|
300: -- ---------------------------------------------------------------------------

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

336: from per_all_people_f
337: where person_id = p_person_id;
338: --
339: begin
340: hr_utility.set_location('Entering:'|| l_proc, 10);
341: --
342: -- Check mandatory parameters have been set
343: --
344: hr_api.mandatory_arg_error

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

346: ,p_argument => 'person_id'
347: ,p_argument_value => p_person_id
348: );
349: --
350: hr_utility.set_location(l_proc, 20);
351: --
352: -- Check that the Person ID is linked to a
353: -- valid person on PER_PEOPLE_F
354: --

Line 360: hr_utility.set_message(800, 'PER_289101_ECA_PERSON_INVALID');

356: fetch csr_valid_pers into l_person_id;
357: if csr_valid_pers%notfound then
358: --
359: close csr_valid_pers;
360: hr_utility.set_message(800, 'PER_289101_ECA_PERSON_INVALID');
361: hr_utility.raise_error;
362: --
363: end if;
364: close csr_valid_pers;

Line 361: hr_utility.raise_error;

357: if csr_valid_pers%notfound then
358: --
359: close csr_valid_pers;
360: hr_utility.set_message(800, 'PER_289101_ECA_PERSON_INVALID');
361: hr_utility.raise_error;
362: --
363: end if;
364: close csr_valid_pers;
365: --

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

362: --
363: end if;
364: close csr_valid_pers;
365: --
366: hr_utility.set_location(' Leaving:'|| l_proc, 50);
367: end chk_person_id;
368: --
369: -- ---------------------------------------------------------------------------
370: -- |---------------------------< chk_election_id >----------------------------|

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

406: from per_elections
407: where election_id = p_election_id;
408: --
409: begin
410: hr_utility.set_location('Entering:'|| l_proc, 10);
411: --
412: -- Check mandatory parameters have been set
413: --
414: hr_api.mandatory_arg_error

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

415: (p_api_name => l_proc
416: ,p_argument => 'election_id'
417: ,p_argument_value => p_election_id
418: );
419: hr_utility.set_location(l_proc, 20);
420: --
421: -- Check that the Election ID is exists in PER_ELECTIONS
422: --
423: open csr_valid_eid;

Line 428: hr_utility.set_message(800, 'PER_289103_ECA_ELEC_ID_INVALID');

424: fetch csr_valid_eid into l_election_id;
425: if csr_valid_eid%notfound then
426: --
427: close csr_valid_eid;
428: hr_utility.set_message(800, 'PER_289103_ECA_ELEC_ID_INVALID');
429: hr_utility.raise_error;
430: --
431: end if;
432: close csr_valid_eid;

Line 429: hr_utility.raise_error;

425: if csr_valid_eid%notfound then
426: --
427: close csr_valid_eid;
428: hr_utility.set_message(800, 'PER_289103_ECA_ELEC_ID_INVALID');
429: hr_utility.raise_error;
430: --
431: end if;
432: close csr_valid_eid;
433: --

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

430: --
431: end if;
432: close csr_valid_eid;
433: --
434: hr_utility.set_location(' Leaving:'|| l_proc, 50);
435: end chk_election_id;
436: --
437: -- ---------------------------------------------------------------------------
438: -- |---------------------< chk_duplicate_candidate >------------------------|

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

478: and person_id = p_person_id;
479: --
480: begin
481:
482: hr_utility.set_location('Entering:'|| l_proc, 10);
483: --
484: -- Check mandatory parameters have been set
485: --
486: hr_api.mandatory_arg_error

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

494: ,p_argument => 'person_id'
495: ,p_argument_value => p_person_id
496: );
497: --
498: hr_utility.set_location(l_proc, 20);
499: --
500: -- Check that the candidate has not been entered for this election before
501: --
502: open csr_valid_candidate;

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

503: fetch csr_valid_candidate into l_candidate_id;
504: if csr_valid_candidate%found then
505: if p_election_candidate_id is null or
506: p_election_candidate_id <> l_candidate_id then
507: hr_utility.set_location(l_proc, 30);
508: --
509: fnd_message.set_name('PER', 'HR_289257_ECA_DUP_CANDIDATE');
510: hr_utility.raise_error;
511: --

Line 510: hr_utility.raise_error;

506: p_election_candidate_id <> l_candidate_id then
507: hr_utility.set_location(l_proc, 30);
508: --
509: fnd_message.set_name('PER', 'HR_289257_ECA_DUP_CANDIDATE');
510: hr_utility.raise_error;
511: --
512: end if;
513: end if;
514: close csr_valid_candidate;

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

512: end if;
513: end if;
514: close csr_valid_candidate;
515: --
516: hr_utility.set_location(' Leaving:'|| l_proc, 50);
517: end chk_duplicate_candidate;
518: --
519: -- ---------------------------------------------------------------------------
520: -- |---------------------------< chk_role_id >----------------------------|

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

556: from per_roles
557: where role_id = p_role_id;
558: --
559: begin
560: hr_utility.set_location('Entering:'|| l_proc, 10);
561: --
562: -- Check mandatory parameters have been set
563: --
564: hr_api.mandatory_arg_error

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

565: (p_api_name => l_proc
566: ,p_argument => 'role_id'
567: ,p_argument_value => p_role_id
568: );
569: hr_utility.set_location(l_proc, 20);
570: --
571: --
572: -- Check that the Role ID is exists in PER_ROLES
573: --

Line 579: hr_utility.set_message(800, 'PER_289104_ECA_ROLE_ID_INVALID');

575: fetch csr_valid_rid into l_role_id;
576: if csr_valid_rid%notfound then
577: --
578: close csr_valid_rid;
579: hr_utility.set_message(800, 'PER_289104_ECA_ROLE_ID_INVALID');
580: hr_utility.raise_error;
581: --
582: end if;
583: close csr_valid_rid; --

Line 580: hr_utility.raise_error;

576: if csr_valid_rid%notfound then
577: --
578: close csr_valid_rid;
579: hr_utility.set_message(800, 'PER_289104_ECA_ROLE_ID_INVALID');
580: hr_utility.raise_error;
581: --
582: end if;
583: close csr_valid_rid; --
584: --

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

581: --
582: end if;
583: close csr_valid_rid; --
584: --
585: hr_utility.set_location(' Leaving:'|| l_proc, 50);
586: end chk_role_id;
587:
588: --
589: -- ----------------------------------------------------------------------------

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

620: --
621: l_proc varchar2(72) := g_package || 'chk_df';
622: --
623: begin
624: hr_utility.set_location('Entering:'||l_proc,10);
625: --
626: if ((p_rec.election_candidate_id is not null) and (
627: nvl(per_eca_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
628: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

759: ,p_attribute30_value => p_rec.attribute30
760: );
761: end if;
762: --
763: hr_utility.set_location(' Leaving:'||l_proc,20);
764: end chk_df;
765: --
766:
767: --

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

799: --
800: l_proc varchar2(72) := g_package || 'chk_ddf';
801: --
802: begin
803: hr_utility.set_location('Entering:'||l_proc,10);
804: --
805: if ((p_rec.election_candidate_id is not null) and (
806: nvl(per_eca_shd.g_old_rec.candidate_info_category, hr_api.g_varchar2) <>
807: nvl(p_rec.candidate_info_category, hr_api.g_varchar2) or

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

938: ,p_attribute30_value => p_rec.candidate_information30
939: );
940: end if;
941: --
942: hr_utility.set_location(' Leaving:'||l_proc,20);
943: end chk_ddf;
944: --
945: -- ----------------------------------------------------------------------------
946: -- |---------------------------< insert_validate >----------------------------|

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

952: l_proc varchar2(72) := g_package||'insert_validate';
953: --
954: --
955: Begin
956: hr_utility.set_location('Entering:'||l_proc, 5);
957: --
958: -- Validate PERSON_ID
959: --
960: per_eca_bus.chk_person_id

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

994: --
995: -- Validate DDFs
996: per_eca_bus.chk_df(p_rec);
997: --
998: hr_utility.set_location(' Leaving:'||l_proc, 10);
999: End insert_validate;
1000: --
1001: -- ----------------------------------------------------------------------------
1002: -- |---------------------------< update_validate >----------------------------|

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

1008: l_proc varchar2(72) := g_package||'insert_validate';
1009: --
1010: --
1011: Begin
1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: -- Validate PERSON_ID
1015: --
1016: per_eca_bus.chk_person_id

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

1051: --
1052: -- Validate DDFs
1053: per_eca_bus.chk_ddf(p_rec);
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056: End update_validate;
1057: end per_eca_bus;