[Home] [Help]
59: ff.legislation_code = l_legislation_code));
60:
61: BEGIN
62:
63: hr_utility.set_location('Entering: '||l_proc, 10);
64:
65: OPEN csr_get_leg_code;
66: FETCH csr_get_leg_code INTO l_legislation_code;
67: CLOSE csr_get_leg_code;
69: OPEN csr_chk_and_return_ff;
70: FETCH csr_chk_and_return_ff INTO l_formula_name;
71: CLOSE csr_chk_and_return_ff;
72:
73: hr_utility.set_location('Leaving: '||l_proc, 20);
74:
75: --
76: -- If no formula is found, l_formula_name will return NULL. This function
77: -- returns null, instead of erroring, because the calling procedure may
129: );
130:
131: BEGIN
132:
133: hr_utility.set_location('Entering: '||l_proc, 10);
134:
135: hr_api.mandatory_arg_error(p_api_name => l_proc,
136: p_argument => 'p_accrual_plan_name',
137: p_argument_value => p_accrual_plan_name);
148: -- Check the value of the local variable.
149: --
150: IF (l_name_exists = 'Y') THEN
151:
152: hr_utility.set_location(l_proc, 20);
153: fnd_message.set_name('PAY', 'HR_13163_PTO_DUP_PLAN_NAME');
154: fnd_message.raise_error;
155:
156: ELSIF (l_name_exists = 'N') THEN
158: FETCH check_dup_tl INTO l_name_exists;
159: CLOSE check_dup_tl;
160:
161: IF (l_name_exists = 'Y') THEN
162: hr_utility.set_location(l_proc, 25);
163: fnd_message.set_name ('PAY','HR_13163_PTO_DUP_PLAN_NAME');
164: fnd_message.raise_error;
165: END IF;
166:
165: END IF;
166:
167: END IF;
168:
169: hr_utility.set_location('Leaving: '||l_proc, 30);
170:
171: END chk_accrual_plan_name;
172: --
173: -- ----------------------------------------------------------------------------
191: l_api_updating BOOLEAN;
192:
193: BEGIN
194:
195: hr_utility.set_location('Entering: '||l_proc, 10);
196:
197: --
198: -- Only proceed with validation if:
199: -- a) inserting or
224:
225: --
226: -- The accrual category does not exist in the lookup.
227: --
228: hr_utility.set_location(l_proc, 20);
229: fnd_message.set_name('PER', 'HR_289325_LEG_ACC_NOT_EXISTS');
230: fnd_message.raise_error;
231:
232: END IF;
230: fnd_message.raise_error;
231:
232: END IF;
233:
234: hr_utility.set_location('Leaving: '||l_proc, 90);
235:
236: END chk_accrual_category;
237: --
238: -- ----------------------------------------------------------------------------
256: l_api_updating BOOLEAN;
257:
258: BEGIN
259:
260: hr_utility.set_location('Entering: '||l_proc, 10);
261:
262: --
263: -- Only proceed with validation if:
264: -- a) inserting or
276: END IF;
277:
278: IF p_accrual_start IS NOT NULL THEN
279:
280: hr_utility.set_location(l_proc, 20);
281:
282: IF hr_api.not_exists_in_hr_lookups
283: (p_effective_date => p_effective_date
284: ,p_lookup_type => 'US_ACCRUAL_START_TYPE'
286:
287: --
288: -- The accrual start does not exist in the lookup.
289: --
290: hr_utility.set_location(l_proc, 30);
291: fnd_message.set_name('PER', 'HR_289814_PAP_START_INVALID');
292: fnd_message.raise_error;
293:
294: END IF;
294: END IF;
295:
296: END IF;
297:
298: hr_utility.set_location('Leaving: '||l_proc, 90);
299:
300: END chk_accrual_start;
301: --
302: -- ----------------------------------------------------------------------------
320: l_api_updating BOOLEAN;
321:
322: BEGIN
323:
324: hr_utility.set_location('Entering: '||l_proc, 10);
325:
326: hr_api.mandatory_arg_error(p_api_name => l_proc,
327: p_argument => 'p_accrual_units_of_measure',
328: p_argument_value => p_accrual_units_of_measure);
334:
335: --
336: -- The accrual UOM does not exist in the lookup.
337: --
338: hr_utility.set_location(l_proc, 20);
339: fnd_message.set_name('PER', 'HR_289815_PAP_UOM_INVALID');
340: fnd_message.raise_error;
341:
342: END IF;
340: fnd_message.raise_error;
341:
342: END IF;
343:
344: hr_utility.set_location('Leaving: '||l_proc, 90);
345:
346: END chk_accrual_units_of_measure;
347: --
348: -- ----------------------------------------------------------------------------
369: l_api_updating BOOLEAN;
370:
371: BEGIN
372:
373: hr_utility.set_location('Entering: '||l_proc, 10);
374:
375: --
376: -- Only proceed with validation if:
377: -- a) inserting or
391: hr_api.mandatory_arg_error(p_api_name => l_proc,
392: p_argument => 'p_accrual_formula_id',
393: p_argument_value => p_accrual_formula_id);
394:
395: hr_utility.set_location(l_proc, 20);
396:
397: l_accrual_formula := return_ff_name
398: (p_effective_date => p_effective_date
399: ,p_business_group_id => p_business_group_id
399: ,p_business_group_id => p_business_group_id
400: ,p_formula_id => p_accrual_formula_id
401: ,p_formula_type_name => 'Accrual');
402:
403: hr_utility.set_location(l_proc, 30);
404:
405: IF l_accrual_formula IS NULL THEN
406:
407: --
406:
407: --
408: -- The formula is not valid so error.
409: --
410: hr_utility.set_location(l_proc, 40);
411: fnd_message.set_name('PER', 'HR_289817_PAP_ACCRUAL_FF');
412: fnd_message.raise_error;
413:
414: END IF;
412: fnd_message.raise_error;
413:
414: END IF;
415:
416: hr_utility.set_location('Leaving: '||l_proc, 90);
417:
418: END chk_accrual_formula_id;
419: --
420: -- ----------------------------------------------------------------------------
443: l_api_updating BOOLEAN;
444:
445: BEGIN
446:
447: hr_utility.set_location('Entering: '||l_proc, 10);
448:
449: --
450: -- Only proceed with validation if:
451: -- a) inserting or
467: hr_api.mandatory_arg_error(p_api_name => l_proc,
468: p_argument => 'p_co_formula_id',
469: p_argument_value => p_co_formula_id);
470:
471: hr_utility.set_location(l_proc, 20);
472:
473: l_co_formula := return_ff_name
474: (p_effective_date => p_effective_date
475: ,p_business_group_id => p_business_group_id
480:
481: --
482: -- The formula is not valid so error.
483: --
484: hr_utility.set_location(l_proc, 30);
485: fnd_message.set_name('PER', 'HR_289817_PAP_ACCRUAL_FF');
486: fnd_message.raise_error;
487:
488: ELSIF l_co_formula IN ('PTO_PAYROLL_CARRYOVER'
494: -- This plan is using a seeded carry over formula,
495: -- get the accrual formula to check compatibility
496: -- (where possible).
497: --
498: hr_utility.set_location(l_proc, 40);
499:
500: --
501: -- First get the accrual formula.
502: -- This function call should always return a value because
508: ,p_business_group_id => p_business_group_id
509: ,p_formula_id => p_accrual_formula_id
510: ,p_formula_type_name => 'Accrual');
511:
512: hr_utility.set_location(l_proc, 50);
513:
514: IF l_accrual_formula IN ('PTO_PAYROLL_CALCULATION'
515: ,'PTO_PAYROLL_BALANCE_CALCULATION'
516: ,'PTO_SIMPLE_MULTIPLIER'
517: ,'PTO_SIMPLE_BALANCE_MULTIPLIER'
518: ,'PTO_HD_ANNIVERSARY_BALANCE'
519: ,'PTO_ROLLING_ACCRUAL') THEN
520:
521: hr_utility.set_location(l_proc, 60);
522: --
523: -- Seeded formula are being used for both the accrual and
524: -- carry over formulae. Check that the two are compatible.
525: --
533: l_accrual_formula <> 'PTO_HD_ANNIVERSARY_BALANCE')
534: OR (l_co_formula = 'PTO_ROLLING_CARRYOVER' AND
535: l_accrual_formula <> 'PTO_ROLLING_ACCRUAL') THEN
536:
537: hr_utility.set_location(l_proc, 70);
538: --
539: -- The carryover and accrual formulae are incompatible.
540: --
541: fnd_message.set_name('PER','HR_289819_PAP_FF_INCOMPATIBLE');
548: END IF;
549:
550: END IF;
551:
552: hr_utility.set_location('Leaving: '||l_proc, 90);
553:
554: END chk_co_formula_id;
555: --
556: -- ----------------------------------------------------------------------------
632: WHERE pbg.business_group_id = p_business_group_id;
633: --
634: BEGIN
635:
636: hr_utility.set_location('Entering: '||l_proc, 10);
637:
638: --
639: -- Only proceed with validation if:
640: -- a) inserting or
656: hr_api.mandatory_arg_error(p_api_name => l_proc,
657: p_argument => 'p_pto_input_value_id',
658: p_argument_value => p_pto_input_value_id);
659:
660: hr_utility.set_location(l_proc, 20);
661:
662: --
663: -- Fetch the legislation code
664: OPEN csr_get_leg_code;
672: CLOSE csr_chk_input_value;
673:
674: IF l_element_type_id IS NULL THEN
675:
676: hr_utility.set_location(l_proc, 20);
677: l_valid := FALSE;
678:
679: ELSE
680:
677: l_valid := FALSE;
678:
679: ELSE
680:
681: hr_utility.set_location(l_proc, 30);
682:
683: --
684: -- Check the element type and corresponding absence element.
685: --
687: FETCH csr_chk_pet_and_paat INTO l_dummy;
688:
689: IF csr_chk_pet_and_paat%NOTFOUND THEN
690:
691: hr_utility.set_location(l_proc, 40);
692: l_valid := FALSE;
693:
694: END IF;
695:
703: fnd_message.raise_error;
704:
705: END IF;
706:
707: hr_utility.set_location('Leaving: '||l_proc, 90);
708:
709: END chk_pto_input_value_id;
710: --
711: -- ----------------------------------------------------------------------------
767: WHERE pbg.business_group_id = p_business_group_id);
768:
769: BEGIN
770:
771: hr_utility.set_location('Entering: '||l_proc, 10);
772:
773: p_check_accrual_ff := FALSE;
774: --
775: -- Only proceed with validation if:
788: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
789: RETURN;
790: END IF;
791:
792: hr_utility.set_location(l_proc, 20);
793:
794: IF p_defined_balance_id IS NOT NULL THEN
795:
796: hr_utility.set_location(l_proc, 30);
792: hr_utility.set_location(l_proc, 20);
793:
794: IF p_defined_balance_id IS NOT NULL THEN
795:
796: hr_utility.set_location(l_proc, 30);
797:
798: IF l_api_updating
799: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
800: <> hr_api.g_number THEN
802: --
803: -- The balance dimension has previously been set and is trying
804: -- to be updated. This is not allowed so error.
805: --
806: hr_utility.set_location(l_proc, 40);
807: fnd_message.set_name('PER','HR_289823_PAP_BAL_DIM_UPDATE');
808: fnd_message.raise_error;
809:
810:
809:
810:
811: END IF;
812:
813: hr_utility.set_location(l_proc, 50);
814:
815: --
816: -- Fetch the name of the accrual formula for later use. This
817: -- should never error or return null because the accrual formula
822: ,p_business_group_id => p_business_group_id
823: ,p_formula_id => p_accrual_formula_id
824: ,p_formula_type_name => 'Accrual');
825:
826: hr_utility.set_location(l_proc, 60);
827:
828: --
829: -- Fetch the balance dimension name.
830: --
831: OPEN csr_get_dim_name;
832: FETCH csr_get_dim_name INTO l_dimension_name;
833: CLOSE csr_get_dim_name;
834:
835: hr_utility.set_location(l_proc, 70);
836:
837: IF l_dimension_name IS NULL THEN
838:
839: --
841: -- balance has already been validated at this stage
842: -- so this would only occur when there is an internal
843: -- error with creating the defined balance).
844: --
845: hr_utility.set_location(l_proc, 80);
846: fnd_message.set_name('PER','HR_289820_PAP_DEF_BAL_INVALID');
847: fnd_message.raise_error;
848:
849: ELSIF l_dimension_name IN ('_ASG_PTO_SM_YTD'
856: --
857: -- This is a seed dimension name, check it is compatible
858: -- with the accrual formula.
859: --
860: hr_utility.set_location(l_proc, 90);
861:
862: IF (l_dimension_name IN ('_ASG_PTO_SM_YTD'
863: ,'_ASG_PTO_DE_SM_YTD') AND
864: l_accrual_formula IN ('PTO_PAYROLL_CALCULATION'
884: --
885: -- The balance dimension conflicts with the accrual
886: -- formula.
887: --
888: hr_utility.set_location(l_proc, 100);
889: fnd_message.set_name('PER', 'HR_289821_PAP_BAL_DIM_CONFLICT');
890: fnd_message.raise_error;
891:
892: END IF;
898: OPEN csr_get_bg_balance_type;
899: FETCH csr_get_bg_balance_type INTO l_balance_type;
900: CLOSE csr_get_bg_balance_type;
901:
902: hr_utility.set_location(l_proc, 110);
903:
904: IF l_balance_type IS NULL THEN
905: --
906: -- Check for a balance type at legislative level.
908: OPEN csr_get_leg_balance_type;
909: FETCH csr_get_leg_balance_type INTO l_balance_type;
910: CLOSE csr_get_leg_balance_type;
911:
912: hr_utility.set_location(l_proc, 120);
913:
914: END IF;
915:
916: IF (l_balance_type = 'DE' AND
921: l_dimension_name IN ('_ASG_PTO_DE_YTD'
922: ,'_ASG_PTO_DE_SM_YTD'
923: ,'_ASG_PTO_DE_HD_YTD')) THEN
924:
925: hr_utility.set_location(l_proc, 130);
926: fnd_message.set_name('PER', 'HR_289822_PAP_BAL_TYPE_DIM');
927: fnd_message.raise_error;
928:
929: END IF;
947: END IF;
948:
949: END IF;
950:
951: hr_utility.set_location('Leaving: '||l_proc, 140);
952:
953: END chk_defined_balance_id;
954: --
955: -- ----------------------------------------------------------------------------
974: l_api_updating BOOLEAN;
975:
976: BEGIN
977:
978: hr_utility.set_location('Entering: '||l_proc, 10);
979:
980: --
981: -- Only proceed with validation if:
982: -- a) inserting or
994: END IF;
995:
996: IF p_ineligible_period_type IS NOT NULL THEN
997:
998: hr_utility.set_location(l_proc, 20);
999:
1000: IF hr_api.not_exists_in_hr_lookups
1001: (p_effective_date => p_effective_date
1002: ,p_lookup_type => 'PROC_PERIOD_TYPE'
1004:
1005: --
1006: -- The ineligible period type does not exist in the lookup.
1007: --
1008: hr_utility.set_location(l_proc, 30);
1009: fnd_message.set_name('PER', 'HR_289816_PAP_INELIG_INVALID');
1010: fnd_message.raise_error;
1011:
1012: END IF;
1012: END IF;
1013:
1014: END IF;
1015:
1016: hr_utility.set_location('Leaving: '||l_proc, 90);
1017:
1018: END chk_ineligible_period_type;
1019: --
1020: -- ----------------------------------------------------------------------------
1042: l_api_updating BOOLEAN;
1043:
1044: BEGIN
1045:
1046: hr_utility.set_location('Entering: '||l_proc, 10);
1047:
1048: --
1049: -- Only proceed with validation if:
1050: -- a) inserting or
1060: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1061: RETURN;
1062: END IF;
1063:
1064: hr_utility.set_location(l_proc, 20);
1065:
1066: IF p_ineligibility_formula_id IS NOT NULL THEN
1067:
1068: hr_utility.set_location(l_proc, 30);
1064: hr_utility.set_location(l_proc, 20);
1065:
1066: IF p_ineligibility_formula_id IS NOT NULL THEN
1067:
1068: hr_utility.set_location(l_proc, 30);
1069: l_ineligible_formula := return_ff_name
1070: (p_effective_date => p_effective_date
1071: ,p_business_group_id => p_business_group_id
1072: ,p_formula_id => p_ineligibility_formula_id
1071: ,p_business_group_id => p_business_group_id
1072: ,p_formula_id => p_ineligibility_formula_id
1073: ,p_formula_type_name => 'Accrual Ineligibility');
1074:
1075: hr_utility.set_location(l_proc, 40);
1076:
1077: IF l_ineligible_formula IS NULL THEN
1078:
1079: --
1078:
1079: --
1080: -- The formula is not valid so error.
1081: --
1082: hr_utility.set_location(l_proc, 50);
1083: fnd_message.set_name('PER', 'HR_289818_PAP_INELIG_FF');
1084: fnd_message.raise_error;
1085:
1086: END IF;
1086: END IF;
1087:
1088: END IF;
1089:
1090: hr_utility.set_location('Leaving: '||l_proc, 90);
1091:
1092: END chk_ineligibility_formula_id;
1093: --
1094: -- ----------------------------------------------------------------------------
1125: --
1126: l_proc varchar2(72) := g_package || 'chk_ddf';
1127: --
1128: begin
1129: hr_utility.set_location('Entering:'||l_proc,10);
1130: --
1131: if ((p_rec.accrual_plan_id is not null) and (
1132: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1133: nvl(p_rec.information_category, hr_api.g_varchar2) or
1262: ,p_attribute30_name => 'INFORMATION30'
1263: );
1264: end if;
1265: --
1266: hr_utility.set_location(' Leaving:'||l_proc,20);
1267: end chk_ddf;
1268:
1269: --
1270: -- ----------------------------------------------------------------------------
1308: l_accrual_meaning varchar2(80);
1309: --
1310: Begin
1311: --
1312: hr_utility.set_location('Entering:'||l_proc, 5);
1313: --
1314: l_api_updating := pay_pap_shd.api_updating
1315: (p_accrual_plan_id => p_accrual_plan_id,
1316: p_object_version_number => p_object_version_number);
1354: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1355: fnd_message.raise_error;
1356: end if;
1357: end if;
1358: hr_utility.set_location('Leaving:'||l_proc, 100);
1359: --
1360: End chk_ddf_context;
1361: --
1362: -- ----------------------------------------------------------------------------
1371: l_proc varchar2(72) := g_package||'insert_validate';
1372:
1373: BEGIN
1374:
1375: hr_utility.set_location('Entering:'||l_proc, 10);
1376:
1377: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1378:
1379: --
1386: (p_accrual_plan_id => p_rec.accrual_plan_id
1387: ,p_accrual_plan_name => p_rec.accrual_plan_name
1388: ,p_business_group_id => p_rec.business_group_id);
1389:
1390: hr_utility.set_location(l_proc, 20);
1391:
1392: --
1393: -- Check the accrual category.
1394: --
1397: ,p_accrual_plan_id => p_rec.accrual_plan_id
1398: ,p_object_version_number => p_rec.object_version_number
1399: ,p_accrual_category => p_rec.accrual_category);
1400:
1401: hr_utility.set_location(l_proc, 30);
1402:
1403: --
1404: -- Check the accrual start.
1405: --
1408: ,p_accrual_plan_id => p_rec.accrual_plan_id
1409: ,p_object_version_number => p_rec.object_version_number
1410: ,p_accrual_start => p_rec.accrual_start);
1411:
1412: hr_utility.set_location(l_proc, 40);
1413:
1414: --
1415: -- Check the accrual UOM.
1416: --
1419: ,p_accrual_plan_id => p_rec.accrual_plan_id
1420: ,p_object_version_number => p_rec.object_version_number
1421: ,p_accrual_units_of_measure => p_rec.accrual_units_of_measure);
1422:
1423: hr_utility.set_location(l_proc, 50);
1424:
1425: --
1426: -- Check the accrual formula.
1427: --
1431: ,p_object_version_number => p_rec.object_version_number
1432: ,p_business_group_id => p_rec.business_group_id
1433: ,p_accrual_formula_id => p_rec.accrual_formula_id);
1434:
1435: hr_utility.set_location(l_proc, 60);
1436:
1437: --
1438: -- Check the carry over formula.
1439: --
1444: ,p_business_group_id => p_rec.business_group_id
1445: ,p_accrual_formula_id => p_rec.accrual_formula_id
1446: ,p_co_formula_id => p_rec.co_formula_id);
1447:
1448: hr_utility.set_location(l_proc, 70);
1449:
1450: --
1451: -- Check the absence element's input value
1452: --
1456: ,p_pto_input_value_id => p_rec.pto_input_value_id
1457: ,p_business_group_id => p_rec.business_group_id
1458: ,p_accrual_units_of_measure => p_rec.accrual_units_of_measure);
1459:
1460: hr_utility.set_location(l_proc, 80);
1461: -- Check the defined balance.
1462: --
1463: chk_defined_balance_id
1464: (p_effective_date => p_effective_date
1468: ,p_accrual_formula_id => p_rec.accrual_formula_id
1469: ,p_defined_balance_id => p_rec.defined_balance_id
1470: ,p_check_accrual_ff => p_check_accrual_ff);
1471:
1472: hr_utility.set_location(l_proc, 90);
1473:
1474: --
1475: -- Check the ineligible period type.
1476: --
1479: ,p_accrual_plan_id => p_rec.accrual_plan_id
1480: ,p_object_version_number => p_rec.object_version_number
1481: ,p_ineligible_period_type => p_rec.ineligible_period_type);
1482:
1483: hr_utility.set_location(l_proc, 100);
1484:
1485: --
1486: -- Check the ineligibility formula.
1487: --
1491: ,p_object_version_number => p_rec.object_version_number
1492: ,p_business_group_id => p_rec.business_group_id
1493: ,p_ineligibility_formula_id => p_rec.ineligibility_formula_id);
1494:
1495: hr_utility.set_location(l_proc, 110);
1496:
1497: --
1498: -- Check the flexfields.
1499: --
1498: -- Check the flexfields.
1499: --
1500: pay_pap_bus.chk_ddf (p_rec);
1501:
1502: hr_utility.set_location(l_proc, 120);
1503:
1504: pay_pap_bus.chk_ddf_context
1505: (p_business_group_id => p_rec.business_group_id
1506: ,p_information_category => p_rec.information_category
1507: ,p_accrual_category => p_rec.accrual_category
1508: ,p_accrual_plan_id => p_rec.accrual_plan_id
1509: ,p_object_version_number => p_rec.object_version_number);
1510:
1511: hr_utility.set_location(' Leaving:'||l_proc, 130);
1512:
1513: END insert_validate;
1514: --
1515: -- ----------------------------------------------------------------------------
1524: l_proc varchar2(72) := g_package||'update_validate';
1525:
1526: BEGIN
1527:
1528: hr_utility.set_location('Entering:'||l_proc, 10);
1529:
1530: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1531:
1532: --
1532: --
1533: -- Call all supporting business operations
1534: --
1535:
1536: hr_utility.set_location(l_proc, 20);
1537:
1538: --
1539: -- Check the accrual category.
1540: --
1543: ,p_accrual_plan_id => p_rec.accrual_plan_id
1544: ,p_object_version_number => p_rec.object_version_number
1545: ,p_accrual_category => p_rec.accrual_category);
1546:
1547: hr_utility.set_location(l_proc, 30);
1548:
1549: --
1550: -- Check the accrual start.
1551: --
1554: ,p_accrual_plan_id => p_rec.accrual_plan_id
1555: ,p_object_version_number => p_rec.object_version_number
1556: ,p_accrual_start => p_rec.accrual_start);
1557:
1558: hr_utility.set_location(l_proc, 40);
1559:
1560: --
1561: -- Check the accrual formula.
1562: --
1566: ,p_object_version_number => p_rec.object_version_number
1567: ,p_business_group_id => p_rec.business_group_id
1568: ,p_accrual_formula_id => p_rec.accrual_formula_id);
1569:
1570: hr_utility.set_location(l_proc, 50);
1571:
1572: --
1573: -- Check the carry over formula.
1574: --
1579: ,p_business_group_id => p_rec.business_group_id
1580: ,p_accrual_formula_id => p_rec.accrual_formula_id
1581: ,p_co_formula_id => p_rec.co_formula_id);
1582:
1583: hr_utility.set_location(l_proc, 60);
1584:
1585:
1586: --
1587: -- Check the absence element's input value
1592: ,p_pto_input_value_id => p_rec.pto_input_value_id
1593: ,p_business_group_id => p_rec.business_group_id
1594: ,p_accrual_units_of_measure => p_rec.accrual_units_of_measure);
1595:
1596: hr_utility.set_location(l_proc, 70);
1597: --
1598: -- Check the defined balance.
1599: --
1600: chk_defined_balance_id
1605: ,p_accrual_formula_id => p_rec.accrual_formula_id
1606: ,p_defined_balance_id => p_rec.defined_balance_id
1607: ,p_check_accrual_ff => p_check_accrual_ff);
1608:
1609: hr_utility.set_location(l_proc, 80);
1610:
1611: --
1612: -- Check the ineligible period type.
1613: --
1616: ,p_accrual_plan_id => p_rec.accrual_plan_id
1617: ,p_object_version_number => p_rec.object_version_number
1618: ,p_ineligible_period_type => p_rec.ineligible_period_type);
1619:
1620: hr_utility.set_location(l_proc, 90);
1621:
1622: --
1623: -- Check the ineligibility formula.
1624: --
1628: ,p_object_version_number => p_rec.object_version_number
1629: ,p_business_group_id => p_rec.business_group_id
1630: ,p_ineligibility_formula_id => p_rec.ineligibility_formula_id);
1631:
1632: hr_utility.set_location(l_proc, 100);
1633:
1634: --
1635: -- Check the flexfields.
1636: --
1635: -- Check the flexfields.
1636: --
1637: pay_pap_bus.chk_ddf (p_rec);
1638:
1639: hr_utility.set_location(l_proc, 110);
1640:
1641: pay_pap_bus.chk_ddf_context
1642: (p_business_group_id => p_rec.business_group_id
1643: ,p_information_category => p_rec.information_category
1644: ,p_accrual_category => p_rec.accrual_category
1645: ,p_accrual_plan_id => p_rec.accrual_plan_id
1646: ,p_object_version_number => p_rec.object_version_number);
1647:
1648: hr_utility.set_location(' Leaving:'||l_proc, 120);
1649:
1650: END update_validate;
1651: --
1652: -- ----------------------------------------------------------------------------
1656: --
1657: l_proc varchar2(72) := g_package||'delete_validate';
1658: --
1659: Begin
1660: hr_utility.set_location('Entering:'||l_proc, 5);
1661: --
1662: -- Call all supporting business operations
1663: --
1664: hr_utility.set_location(' Leaving:'||l_proc, 10);
1660: hr_utility.set_location('Entering:'||l_proc, 5);
1661: --
1662: -- Call all supporting business operations
1663: --
1664: hr_utility.set_location(' Leaving:'||l_proc, 10);
1665: End delete_validate;
1666: --
1667: --
1668: -- ---------------------------------------------------------------------------
1687: l_proc varchar2(72) := g_package||'return_legislation_code';
1688: --
1689: begin
1690: --
1691: hr_utility.set_location('Entering:'|| l_proc, 10);
1692: --
1693: -- Ensure that all the mandatory parameter are not null
1694: --
1695: hr_api.mandatory_arg_error(p_api_name => l_proc,
1712: end if;
1713: --
1714: close csr_leg_code;
1715: --
1716: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1717: --
1718: return l_legislation_code;
1719: --
1720: end return_legislation_code;
1742: --
1743: l_security_group_id number;
1744: l_proc varchar2(72) := g_package||'set_security_group_id';
1745: begin
1746: hr_utility.set_location('Entering:'|| l_proc, 10);
1747: --
1748: -- Ensure that all the mandatory parameter are not null
1749: --
1750: hr_api.mandatory_arg_error(p_api_name => l_proc,
1768: hr_api.set_security_group_id
1769: (p_security_group_id => l_security_group_id
1770: );
1771: --
1772: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1773: end set_security_group_id;
1774: --
1775: */
1776: end pay_pap_bus;