[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_etd_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_dpnt_othr_ptip_id => p_elig_dpnt_othr_ptip_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_dpnt_othr_ptip_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_etd_shd.api_updating
118: (p_elig_dpnt_othr_ptip_id => p_elig_dpnt_othr_ptip_id,
119: p_effective_date => p_effective_date,
140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_excld_flag;
147: --
148: --Bug:5054189
189: and ordr_num = p_ordr_num
190: and business_group_id = p_business_group_id;
191: --
192: Begin
193: hr_utility.set_location('Entering:'||l_proc, 5);
194: --
195: open c1;
196: fetch c1 into l_dummy;
197: if c1%found then
200: fnd_message.raise_error;
201: end if;
202: close c1;
203: --
204: hr_utility.set_location('Leaving:'||l_proc, 15);
205: End chk_duplicate_ordr_num;
206: -- ----------------------------------------------------------------------------
207: -- |--------------------------< dt_update_validate >--------------------------|
208: -- ----------------------------------------------------------------------------
244: l_integrity_error Exception;
245: l_table_name all_tables.table_name%TYPE;
246: --
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: -- Ensure that the p_datetrack_mode argument is not null
251: --
252: hr_api.mandatory_arg_error
293: End If;
294: --
295: End If;
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 10);
298: Exception
299: When l_integrity_error Then
300: --
301: -- A referential integrity check was violated therefore
358: l_rows_exist Exception;
359: l_table_name all_tables.table_name%TYPE;
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: -- Ensure that the p_datetrack_mode argument is not null
365: --
366: hr_api.mandatory_arg_error
395: --
396: --
397: End If;
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: Exception
401: When l_rows_exist Then
402: --
403: -- A referential integrity check was violated therefore
427: --
428: l_proc varchar2(72) := g_package||'insert_validate';
429: --
430: Begin
431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Call all supporting business operations
434: --
435: chk_elig_dpnt_othr_ptip_id
450: ,p_business_group_id => p_rec.business_group_id);
451: --
452: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End insert_validate;
456: --
457: -- ----------------------------------------------------------------------------
458: -- |---------------------------< update_validate >----------------------------|
466: --
467: l_proc varchar2(72) := g_package||'update_validate';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: -- Call all supporting business operations
473: --
474: chk_elig_dpnt_othr_ptip_id
499: p_datetrack_mode => p_datetrack_mode,
500: p_validation_start_date => p_validation_start_date,
501: p_validation_end_date => p_validation_end_date);
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: End update_validate;
505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< delete_validate >----------------------------|
515: --
516: l_proc varchar2(72) := g_package||'delete_validate';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call all supporting business operations
522: --
523: dt_delete_validate
525: p_validation_start_date => p_validation_start_date,
526: p_validation_end_date => p_validation_end_date,
527: p_elig_dpnt_othr_ptip_id => p_rec.elig_dpnt_othr_ptip_id);
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
530: End delete_validate;
531: --
532: --
533: -- ---------------------------------------------------------------------------
552: l_proc varchar2(72) := g_package||'return_legislation_code';
553: --
554: begin
555: --
556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: --
558: -- Ensure that all the mandatory parameter are not null
559: --
560: hr_api.mandatory_arg_error(p_api_name => l_proc,
577: end if;
578: --
579: close csr_leg_code;
580: --
581: hr_utility.set_location(' Leaving:'|| l_proc, 20);
582: --
583: return l_legislation_code;
584: --
585: end return_legislation_code;