40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_agf_shd.api_updating
47: (p_age_fctr_id => p_age_fctr_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_age_fctr_id;
75: --
76: /*
113: where a.organization_id = p_organization_id;
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc,5);
118: --
119: l_api_updating := ben_agf_shd.api_updating
120: (p_age_fctr_id => p_age_fctr_id,
121: p_object_version_number => p_object_version_number);
144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_organization_id;
151: */
152: --
185: l_api_updating boolean;
186: --
187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_agf_shd.api_updating
192: (p_age_fctr_id => p_age_fctr_id,
193: p_object_version_number => p_object_version_number);
215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_age_to_use_cd;
222: --
223: -- ----------------------------------------------------------------------------
257: l_api_updating boolean;
258: --
259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_agf_shd.api_updating
264: (p_age_fctr_id => p_age_fctr_id,
265: p_object_version_number => p_object_version_number);
302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: end chk_rndg_rl;
309: --
310: -- ----------------------------------------------------------------------------
343: l_api_updating boolean;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_agf_shd.api_updating
350: (p_age_fctr_id => p_age_fctr_id,
351: p_object_version_number => p_object_version_number);
374: end if;
375: --
376: end if;
377: --
378: hr_utility.set_location('Leaving:'||l_proc,10);
379: --
380: end chk_age_calc_rl;
381: -- ----------------------------------------------------------------------------
382: -- |-----------------------------< chk_age_code_rule >------------------------|
408: l_proc varchar2(72) := g_package||'chk_age_code_rule';
409: --
410: Begin
411: --
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: --
414: if p_age_to_use_cd is null and
415: p_age_calc_rl is null or
416: p_age_to_use_cd is not null and
422: fnd_message.raise_error;
423: --
424: end if;
425: --
426: hr_utility.set_location('Leaving:'||l_proc,10);
427: --
428: end chk_age_code_rule;
429: -- ----------------------------------------------------------------------------
430: -- |------< chk_rndg_cd >------|
461: l_api_updating boolean;
462: --
463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_agf_shd.api_updating
468: (p_age_fctr_id => p_age_fctr_id,
469: p_object_version_number => p_object_version_number);
491: end if;
492: --
493: end if;
494: --
495: hr_utility.set_location('Leaving:'||l_proc,10);
496: --
497: end chk_rndg_cd;
498: --
499: -- ----------------------------------------------------------------------------
534: l_api_updating boolean;
535: --
536: Begin
537: --
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: l_api_updating := ben_agf_shd.api_updating
541: (p_age_fctr_id => p_age_fctr_id,
542: p_object_version_number => p_object_version_number);
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: hr_utility.set_location('Leaving:'||l_proc,10);
586: --
587: end chk_age_det_rl;
588: --
589: -- ----------------------------------------------------------------------------
621: l_api_updating boolean;
622: --
623: Begin
624: --
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: l_api_updating := ben_agf_shd.api_updating
628: (p_age_fctr_id => p_age_fctr_id,
629: p_object_version_number => p_object_version_number);
651: end if;
652: --
653: end if;
654: --
655: hr_utility.set_location('Leaving:'||l_proc,10);
656: --
657: end chk_age_det_cd;
658: --
659: -- ----------------------------------------------------------------------------
691: l_api_updating boolean;
692: --
693: Begin
694: --
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: l_api_updating := ben_agf_shd.api_updating
698: (p_age_fctr_id => p_age_fctr_id,
699: p_object_version_number => p_object_version_number);
721: end if;
722: --
723: end if;
724: --
725: hr_utility.set_location('Leaving:'||l_proc,10);
726: --
727: end chk_no_mx_age_flag;
728: --
729: -- ----------------------------------------------------------------------------
761: l_api_updating boolean;
762: --
763: Begin
764: --
765: hr_utility.set_location('Entering:'||l_proc, 5);
766: --
767: l_api_updating := ben_agf_shd.api_updating
768: (p_age_fctr_id => p_age_fctr_id,
769: p_object_version_number => p_object_version_number);
791: end if;
792: --
793: end if;
794: --
795: hr_utility.set_location('Leaving:'||l_proc,10);
796: --
797: end chk_no_mn_age_flag;
798: --
799: -- ----------------------------------------------------------------------------
831: l_api_updating boolean;
832: --
833: Begin
834: --
835: hr_utility.set_location('Entering:'||l_proc, 5);
836: --
837: l_api_updating := ben_agf_shd.api_updating
838: (p_age_fctr_id => p_age_fctr_id,
839: p_object_version_number => p_object_version_number);
861: end if;
862: --
863: end if;
864: --
865: hr_utility.set_location('Leaving:'||l_proc,10);
866: --
867: end chk_age_uom;
868: --
869: ------------------------------------------------------------------------
909: l_dummy varchar2(1);
910: --
911: Begin
912: --
913: hr_utility.set_location('Entering:'||l_proc, 5);
914: --
915: -- Minimum Age Number must be < Maximum Age Number,
916: -- if both are used.
917: --
960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;
962: end if;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);
965: --
966: end chk_mn_mx_age_num;
967: ------------------------------------------------------------------------
968: ----
1009: where agf.business_group_id = p_business_group_id and
1010: agf.name = p_name;
1011: Begin
1012: --
1013: hr_utility.set_location('Entering:'||l_proc, 5);
1014: --
1015: l_api_updating := ben_agf_shd.api_updating
1016: (p_age_fctr_id => p_age_fctr_id,
1017: -- p_effective_date => p_effective_date,
1044: --
1045: close c1;
1046: end if;
1047: --
1048: hr_utility.set_location('Leaving:'||l_proc,10);
1049: --
1050: end chk_name;
1051: --
1052:
1084: where cla.age_fctr_id = p_age_fctr_id;
1085:
1086: begin
1087: --
1088: hr_utility.set_location('Entering:'||l_proc, 5);
1089: --
1090: -- check if age factor record exists in the ben_cmbn_age_los_fctr table
1091: --
1092: /* open chk_cmbn_age_los_fctr;
1150:
1151:
1152: --Bug 2978945
1153:
1154: hr_utility.set_location('Leaving:'||l_proc,10);
1155: --
1156:
1157: end chk_child_records;
1158:
1167: --
1168: l_proc varchar2(72) := g_package||'insert_validate';
1169: --
1170: Begin
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: --
1173: -- Call all supporting business operations
1174: --
1175: --
1263: chk_age_code_rule
1264: (p_age_to_use_cd => p_rec.age_to_use_cd,
1265: p_age_calc_rl => p_rec.age_calc_rl);
1266: --
1267: hr_utility.set_location(' Leaving:'||l_proc, 10);
1268: End insert_validate;
1269: --
1270: -- ----------------------------------------------------------------------------
1271: -- |---------------------------< update_validate >----------------------------|
1275: --
1276: l_proc varchar2(72) := g_package||'update_validate';
1277: --
1278: Begin
1279: hr_utility.set_location('Entering:'||l_proc, 5);
1280: --
1281: -- Call all supporting business operations
1282: --
1283: --
1371: chk_age_code_rule
1372: (p_age_to_use_cd => p_rec.age_to_use_cd,
1373: p_age_calc_rl => p_rec.age_calc_rl);
1374: --
1375: hr_utility.set_location(' Leaving:'||l_proc, 10);
1376: End update_validate;
1377: --
1378: -- ----------------------------------------------------------------------------
1379: -- |---------------------------< delete_validate >----------------------------|
1383: --
1384: l_proc varchar2(72) := g_package||'delete_validate';
1385: --
1386: Begin
1387: hr_utility.set_location('Entering:'||l_proc, 5);
1388: --
1389: -- Call all supporting business operations
1390: chk_child_records(p_age_fctr_id => p_rec.age_fctr_id);
1391: --
1388: --
1389: -- Call all supporting business operations
1390: chk_child_records(p_age_fctr_id => p_rec.age_fctr_id);
1391: --
1392: hr_utility.set_location(' Leaving:'||l_proc, 10);
1393: End delete_validate;
1394: --
1395: --
1396: -- ---------------------------------------------------------------------------
1415: l_proc varchar2(72) := g_package||'return_legislation_code';
1416: --
1417: begin
1418: --
1419: hr_utility.set_location('Entering:'|| l_proc, 10);
1420: --
1421: -- Ensure that all the mandatory parameter are not null
1422: --
1423: hr_api.mandatory_arg_error(p_api_name => l_proc,
1433: close csr_leg_code;
1434: --
1435: -- The primary key is invalid therefore we must error
1436: --
1437: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1438: hr_utility.raise_error;
1439: --
1440: end if;
1441: --
1434: --
1435: -- The primary key is invalid therefore we must error
1436: --
1437: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1438: hr_utility.raise_error;
1439: --
1440: end if;
1441: --
1442: close csr_leg_code;
1440: end if;
1441: --
1442: close csr_leg_code;
1443: --
1444: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1445: --
1446: return l_legislation_code;
1447: --
1448: end return_legislation_code;