42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ptp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_typ_id => p_pl_typ_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pl_typ_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_ptp_shd.api_updating
118: (p_pl_typ_id => p_pl_typ_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_no_mn_enrl_num_dfnd_flag;
147: --
148: -- ----------------------------------------------------------------------------
180: l_api_updating boolean;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_ptp_shd.api_updating
187: (p_pl_typ_id => p_pl_typ_id,
188: p_effective_date => p_effective_date,
209: end if;
210: --
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: end chk_no_mx_enrl_num_dfnd_flag;
216: --
217: -- ----------------------------------------------------------------------------
249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_ptp_shd.api_updating
256: (p_pl_typ_id => p_pl_typ_id,
257: p_effective_date => p_effective_date,
278: end if;
279: --
280: end if;
281: --
282: hr_utility.set_location('Leaving:'||l_proc,10);
283: --
284: end chk_opt_typ_cd;
285: --
286: -- ----------------------------------------------------------------------------
343: --
344:
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_ptp_shd.api_updating
350: (p_pl_typ_id => p_pl_typ_id,
351: p_effective_date => p_effective_date,
376: --
377: --
378: end if;
379: --
380: hr_utility.set_location('Leaving:'||l_proc,10);
381: --
382: end chk_irec_pln_in_rptg_grp;
383: --
384: -- ----------------------------------------------------------------------------
417: l_api_updating boolean;
418: --
419: Begin
420: --
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: l_api_updating := ben_ptp_shd.api_updating
424: (p_pl_typ_id => p_pl_typ_id,
425: p_effective_date => p_effective_date,
470: --iRec
471: --
472: end if;
473: --
474: hr_utility.set_location('Leaving:'||l_proc,10);
475: --
476: end chk_opt_dsply_fmt_cd;
477: --
478: -- ----------------------------------------------------------------------------
510: l_api_updating boolean;
511: --
512: Begin
513: --
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: l_api_updating := ben_ptp_shd.api_updating
517: (p_pl_typ_id => p_pl_typ_id,
518: p_effective_date => p_effective_date,
540: end if;
541: --
542: end if;
543: --
544: hr_utility.set_location('Leaving:'||l_proc,10);
545: --
546: end chk_comp_typ_cd;
547: --
548: -- ----------------------------------------------------------------------------
580: l_api_updating boolean;
581: --
582: Begin
583: --
584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: l_api_updating := ben_ptp_shd.api_updating
587: (p_pl_typ_id => p_pl_typ_id,
588: p_effective_date => p_effective_date,
609: end if;
610: --
611: end if;
612: --
613: hr_utility.set_location('Leaving:'||l_proc,10);
614: --
615: end chk_pl_typ_stat_cd;
616:
617:
671: and p_validation_end_date >= effective_start_date;
672: --
673: Begin
674: --
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: --
677: l_api_updating := ben_ptp_shd.api_updating
678: (p_effective_date => p_effective_date,
679: p_pl_typ_id => p_pl_typ_id,
682: if (l_api_updating
683: and p_name <> ben_ptp_shd.g_old_rec.name) or
684: not l_api_updating then
685: --
686: hr_utility.set_location('Entering:'||l_proc, 10);
687: --
688: -- check if this name already exist
689: --
690: open csr_name;
703: close csr_name;
704: --
705: end if;
706: --
707: hr_utility.set_location('Leaving:'||l_proc, 20);
708: --
709: End chk_name;
710: --
711:
754: l_dummy varchar2(1);
755: --
756: Begin
757: --
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Maximum enrollments allowed nuumber
761: -- >= Minimum enrollments allowed number.
762: -- if both are used.
788: fnd_message.raise_error;
789: end if;
790: --
791: --
792: hr_utility.set_location('Leaving:'||l_proc,10);
793: --
794: end chk_mn_mx_num;
795:
796:
852:
853: --
854: Begin
855: --
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: --
859: l_api_updating := ben_ptp_shd.api_updating
860: (p_effective_date => p_effective_date,
883: --
884: end if;
885: --
886:
887: hr_utility.set_location('Leaving:'||l_proc,10);
888: --
889: end chk_gsp_opt_typ_cd;
890:
891: --
928: l_integrity_error Exception;
929: l_table_name all_tables.table_name%TYPE;
930: --
931: Begin
932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: -- Ensure that the p_datetrack_mode argument is not null
935: --
936: hr_api.mandatory_arg_error
958: --
959: --
960: End If;
961: --
962: hr_utility.set_location(' Leaving:'||l_proc, 10);
963: Exception
964: When l_integrity_error Then
965: --
966: -- A referential integrity check was violated therefore
1025: l_rows_exist Exception;
1026: l_table_name all_tables.table_name%TYPE;
1027: --
1028: Begin
1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: -- Ensure that the p_datetrack_mode argument is not null
1032: --
1033: hr_api.mandatory_arg_error
1089: End If;
1090: --
1091: End If;
1092: --
1093: hr_utility.set_location(' Leaving:'||l_proc, 10);
1094: Exception
1095: When l_rows_exist Then
1096: --
1097: -- A referential integrity check was violated therefore
1123: --
1124: l_proc varchar2(72) := g_package||'insert_validate';
1125: --
1126: Begin
1127: hr_utility.set_location('Entering:'||l_proc, 5);
1128: --
1129: -- Call all supporting business operations
1130: --
1131: --
1199: --p_validation_end_date
1200: p_business_group_id => p_rec.business_group_id,
1201: p_object_version_number => p_rec.object_version_number ) ;
1202: --
1203: hr_utility.set_location(' Leaving:'||l_proc, 10);
1204: End insert_validate;
1205: --
1206: -- ----------------------------------------------------------------------------
1207: -- |---------------------------< update_validate >----------------------------|
1215: --
1216: l_proc varchar2(72) := g_package||'update_validate';
1217: --
1218: Begin
1219: hr_utility.set_location('Entering:'||l_proc, 5);
1220: --
1221: -- Call all supporting business operations
1222: --
1223: --
1309: p_datetrack_mode => p_datetrack_mode,
1310: p_validation_start_date => p_validation_start_date,
1311: p_validation_end_date => p_validation_end_date);
1312: --
1313: hr_utility.set_location(' Leaving:'||l_proc, 10);
1314: End update_validate;
1315: --
1316: -- ----------------------------------------------------------------------------
1317: -- |---------------------------< delete_validate >----------------------------|
1325: --
1326: l_proc varchar2(72) := g_package||'delete_validate';
1327: --
1328: Begin
1329: hr_utility.set_location('Entering:'||l_proc, 5);
1330: --
1331: -- Call all supporting business operations
1332: --
1333: dt_delete_validate
1335: p_validation_start_date => p_validation_start_date,
1336: p_validation_end_date => p_validation_end_date,
1337: p_pl_typ_id => p_rec.pl_typ_id);
1338: --
1339: hr_utility.set_location(' Leaving:'||l_proc, 10);
1340: End delete_validate;
1341: --
1342: --
1343: -- ---------------------------------------------------------------------------
1364:
1365: --
1366: begin
1367: --
1368: hr_utility.set_location('Entering:'|| l_proc, 10);
1369: --
1370: -- Ensure that all the mandatory parameter are not null
1371: --
1372: hr_api.mandatory_arg_error(p_api_name => l_proc,
1389: end if;
1390: --
1391: close csr_leg_code;
1392: --
1393: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1394: --
1395: return l_legislation_code;
1396:
1397: --