[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_dot_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_othr_ptip_rt_id => p_dpnt_othr_ptip_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_dpnt_othr_ptip_rt_id;
78: -- ----------------------------------------------------------------------------
79: -- |------< chk_dup_record >------|
131: and p_validation_end_date >= effective_start_date;
132: --
133: BEGIN
134: --
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: l_api_updating := ben_dot_shd.api_updating
138: (p_dpnt_othr_ptip_rt_id => p_dpnt_othr_ptip_rt_id,
139: p_effective_date => p_effective_date,
159: end if;
160: close c_dup;
161: --
162: end if;
163: hr_utility.set_location('Leaving:'||l_proc,10);
164: --
165: END chk_dup_record;
166:
167: --
200: l_api_updating boolean;
201: --
202: Begin
203: --
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: l_api_updating := ben_dot_shd.api_updating
207: (p_dpnt_othr_ptip_rt_id => p_dpnt_othr_ptip_rt_id,
208: p_effective_date => p_effective_date,
229: end if;
230: --
231: end if;
232: --
233: hr_utility.set_location('Leaving:'||l_proc,10);
234: --
235: end chk_excld_flag;
236: --
237: --
286: and business_group_id + 0 = p_business_group_id
287: and ordr_num = p_ordr_num;
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291:
292: --
293: open c1;
294: fetch c1 into l_dummy;
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
303: End chk_duplicate_ordr_num;
304:
305:
306:
346: l_integrity_error Exception;
347: l_table_name all_tables.table_name%TYPE;
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Ensure that the p_datetrack_mode argument is not null
353: --
354: hr_api.mandatory_arg_error
395: End If;
396: --
397: End If;
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: Exception
401: When l_integrity_error Then
402: --
403: -- A referential integrity check was violated therefore
460: l_rows_exist Exception;
461: l_table_name all_tables.table_name%TYPE;
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Ensure that the p_datetrack_mode argument is not null
467: --
468: hr_api.mandatory_arg_error
497: --
498: --
499: End If;
500: --
501: hr_utility.set_location(' Leaving:'||l_proc, 10);
502: Exception
503: When l_rows_exist Then
504: --
505: -- A referential integrity check was violated therefore
529: --
530: l_proc varchar2(72) := g_package||'insert_validate';
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Call all supporting business operations
536: --
537: chk_dpnt_othr_ptip_rt_id
566:
567: --
568: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: End insert_validate;
572: --
573: -- ----------------------------------------------------------------------------
574: -- |---------------------------< update_validate >----------------------------|
582: --
583: l_proc varchar2(72) := g_package||'update_validate';
584: --
585: Begin
586: hr_utility.set_location('Entering:'||l_proc, 5);
587: --
588: -- Call all supporting business operations
589: --
590: chk_dpnt_othr_ptip_rt_id
629: p_datetrack_mode => p_datetrack_mode,
630: p_validation_start_date => p_validation_start_date,
631: p_validation_end_date => p_validation_end_date);
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: End update_validate;
635: --
636: -- ----------------------------------------------------------------------------
637: -- |---------------------------< delete_validate >----------------------------|
645: --
646: l_proc varchar2(72) := g_package||'delete_validate';
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Call all supporting business operations
652: --
653: dt_delete_validate
655: p_validation_start_date => p_validation_start_date,
656: p_validation_end_date => p_validation_end_date,
657: p_dpnt_othr_ptip_rt_id => p_rec.dpnt_othr_ptip_rt_id);
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 10);
660: End delete_validate;
661: --
662: --
663: -- ---------------------------------------------------------------------------
682: l_proc varchar2(72) := g_package||'return_legislation_code';
683: --
684: begin
685: --
686: hr_utility.set_location('Entering:'|| l_proc, 10);
687: --
688: -- Ensure that all the mandatory parameter are not null
689: --
690: hr_api.mandatory_arg_error(p_api_name => l_proc,
707: end if;
708: --
709: close csr_leg_code;
710: --
711: hr_utility.set_location(' Leaving:'|| l_proc, 20);
712: --
713: return l_legislation_code;
714: --
715: end return_legislation_code;