[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_cpr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_popl_org_role_id => p_popl_org_role_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_popl_org_role_id;
78: --
79: -- ----------------------------------------------------------------------------
124: and pln.effective_end_date
125: and pln.pl_cd = 'MSTBPGM'; -- must be in program
126: Begin
127: --
128: hr_utility.set_location('Entering:'||l_proc, 5);
129: --
130: l_api_updating := ben_cpr_shd.api_updating
131: (p_popl_org_role_id => p_popl_org_role_id,
132: p_effective_date => p_effective_date,
169: end if;
170:
171: end if;
172: --
173: hr_utility.set_location('Leaving:'||l_proc,10);
174: --
175: end chk_org_role_typ_cd;
176: -- --
177: --
238: and p_effective_date between cpr.effective_start_date
239: and cpr.effective_end_date;
240:
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243:
244: if p_org_role_typ_cd = 'PCP' then
245: open get_grp_and_pl_id;
246: fetch get_grp_and_pl_id into l_pl_id, l_plcy_r_grp;
273: fnd_message.raise_error;
274: end if;
275: end if;
276:
277: hr_utility.set_location('Leaving:'||l_proc, 15);
278:
279: End chk_uniq_org_role_typ;
280: --
281: --
318: l_integrity_error Exception;
319: l_table_name all_tables.table_name%TYPE;
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
348: --
349: --
350: End If;
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: Exception
354: When l_integrity_error Then
355: --
356: -- A referential integrity check was violated therefore
415: l_rows_exist Exception;
416: l_table_name all_tables.table_name%TYPE;
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Ensure that the p_datetrack_mode argument is not null
422: --
423: hr_api.mandatory_arg_error
450: p_argument_value => p_popl_org_role_id);
451: --
452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception
456: When l_rows_exist Then
457: --
458: -- A referential integrity check was violated therefore
484: --
485: l_proc varchar2(72) := g_package||'insert_validate';
486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: --
490: -- Call all supporting business operations
491: --
492: --
510: p_org_role_typ_cd => p_rec.org_role_typ_cd,
511: p_business_group_id => p_rec.business_group_id,
512: p_effective_date => p_effective_date);
513:
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: End insert_validate;
516: --
517: -- ----------------------------------------------------------------------------
518: -- |---------------------------< update_validate >----------------------------|
526: --
527: l_proc varchar2(72) := g_package||'update_validate';
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Call all supporting business operations
533: --
534: --
559: p_datetrack_mode => p_datetrack_mode,
560: p_validation_start_date => p_validation_start_date,
561: p_validation_end_date => p_validation_end_date);
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 10);
564: End update_validate;
565: --
566: -- ----------------------------------------------------------------------------
567: -- |---------------------------< delete_validate >----------------------------|
575: --
576: l_proc varchar2(72) := g_package||'delete_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call all supporting business operations
582: --
583: dt_delete_validate
585: p_validation_start_date => p_validation_start_date,
586: p_validation_end_date => p_validation_end_date,
587: p_popl_org_role_id => p_rec.popl_org_role_id);
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 10);
590: End delete_validate;
591: --
592: --
593: -- ---------------------------------------------------------------------------
612: l_proc varchar2(72) := g_package||'return_legislation_code';
613: --
614: begin
615: --
616: hr_utility.set_location('Entering:'|| l_proc, 10);
617: --
618: -- Ensure that all the mandatory parameter are not null
619: --
620: hr_api.mandatory_arg_error(p_api_name => l_proc,
637: end if;
638: --
639: close csr_leg_code;
640: --
641: hr_utility.set_location(' Leaving:'|| l_proc, 20);
642: --
643: return l_legislation_code;
644: --
645: end return_legislation_code;