[Home] [Help]
33: l_legislation_code varchar2(150);
34: --
35: begin
36: --
37: hr_utility.set_location('Entering:'|| l_proc, 10);
38: --
39: -- Ensure that all the mandatory parameter are not null
40: --
41: hr_api.mandatory_arg_error
73: --
74: hr_api.set_legislation_context(l_legislation_code);
75: end if;
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);
78: --
79: end set_security_group_id;
80: --
81: -- ---------------------------------------------------------------------------
94: l_exists varchar2(1);
95: --
96: Begin
97: --
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: --
100: hr_api.mandatory_arg_error
101: ( p_api_name => l_proc
102: ,p_argument => 'REPORT_FORMAT_MAPPING_ID'
116: end if ;
117:
118: close csr_unique_id;
119: --
120: hr_utility.set_location(' Leaving:'|| l_proc, 20);
121: --
122: End chk_report_format_mapping_id;
123: --
124: -- ----------------------------------------------------------------------------
168: l_exists varchar2(1);
169: --
170: Begin
171: --
172: hr_utility.set_location('Entering:'|| l_proc, 10);
173: --
174: hr_api.mandatory_arg_error
175: ( p_api_name => l_proc
176: ,p_argument => 'REPORT_TYPE'
208: end if ;
209:
210: close csr_unique_key;
211: --
212: hr_utility.set_location(' Leaving:'|| l_proc, 20);
213: --
214: End chk_unique_key;
215: --
216: -- ----------------------------------------------------------------------------
247: l_proc varchar2(72) := g_package || 'chk_report_format';
248: --
249: Begin
250: --
251: hr_utility.set_location('Entering:'|| l_proc, 10);
252: --
253: hr_api.mandatory_arg_error
254: ( p_api_name => l_proc
255: ,p_argument => 'REPORT_FORMAT'
255: ,p_argument => 'REPORT_FORMAT'
256: ,p_argument_value => p_report_format
257: );
258: --
259: hr_utility.set_location(' Leaving:'|| l_proc, 20);
260: --
261: End chk_report_format;
262: --
263: -- ----------------------------------------------------------------------------
293: l_proc varchar2(72) := g_package || 'chk_updatable_flag';
294: --
295: Begin
296: --
297: hr_utility.set_location('Entering:'|| l_proc, 10);
298: --
299:
300: if p_updatable_flag is not null and
301: p_updatable_flag not in ('Y', 'N') then
305:
306: end if;
307:
308: --
309: hr_utility.set_location(' Leaving:'|| l_proc, 20);
310: --
311: End chk_updatable_flag;
312: --
313: -- ----------------------------------------------------------------------------
347: l_proc varchar2(100) := g_package || 'chk_legislation_code';
348: --
349: Begin
350: --
351: hr_utility.set_location('Entering:'|| l_proc, 10);
352:
353: open csr_legislation_code;
354: fetch csr_legislation_code into l_exists ;
355:
359: fnd_message.raise_error;
360: end if;
361: close csr_legislation_code;
362:
363: hr_utility.set_location(' Leaving:'|| l_proc, 20);
364: --
365: End chk_legislation_code;
366: --
367: -- ----------------------------------------------------------------------------
440: l_exists varchar2(1);
441: --
442: Begin
443: --
444: hr_utility.set_location('Entering:'|| l_proc, 10);
445:
446: if p_datetrack_mode = hr_api.g_delete then
447:
448: open csr_dt_rfi_exists;
502: close csr_rftl_exists;
503:
504: end if;
505:
506: hr_utility.set_location(' Leaving:'|| l_proc, 20);
507: --
508: End chk_delete;
509: --
510: -- ----------------------------------------------------------------------------
837: --
838: l_proc varchar2(72) := g_package||'insert_validate';
839: --
840: Begin
841: hr_utility.set_location('Entering:'||l_proc, 5);
842: --
843: -- Call all supporting business operations
844: --
845: --
886: --
887: chk_updatable_flag
888: ( p_updatable_flag => p_rec.updatable_flag );
889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 10);
891: End insert_validate;
892: --
893: -- ----------------------------------------------------------------------------
894: -- |---------------------------< update_validate >----------------------------|
903: --
904: l_proc varchar2(72) := g_package||'update_validate';
905: --
906: Begin
907: hr_utility.set_location('Entering:'||l_proc, 5);
908: --
909: -- Call all supporting business operations
910: --
911: --
951: --
952: chk_updatable_flag
953: ( p_updatable_flag => p_rec.updatable_flag );
954: --
955: hr_utility.set_location(' Leaving:'||l_proc, 10);
956: End update_validate;
957: --
958: -- ----------------------------------------------------------------------------
959: -- |---------------------------< delete_validate >----------------------------|
968: --
969: l_proc varchar2(72) := g_package||'delete_validate';
970: --
971: Begin
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: --
975: chk_startup_action(false
976: ,pay_rfm_shd.g_old_rec.business_group_id
1005: ,p_validation_start_date => p_validation_start_date
1006: ,p_validation_end_date => p_validation_end_date
1007: );
1008: --
1009: hr_utility.set_location(' Leaving:'||l_proc, 10);
1010: End delete_validate;
1011: --
1012: end pay_rfm_bus;