[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
114: pap.accrual_plan_id <> p_accrual_plan_id));
115:
116: BEGIN
117:
118: hr_utility.set_location('Entering: '||l_proc, 10);
119:
120: hr_api.mandatory_arg_error(p_api_name => l_proc,
121: p_argument => 'p_accrual_plan_name',
122: p_argument_value => p_accrual_plan_name);
133: -- Check the value of the local variable.
134: --
135: IF (l_name_exists = 'Y') THEN
136:
137: hr_utility.set_location(l_proc, 20);
138: fnd_message.set_name('PAY', 'HR_13163_PTO_DUP_PLAN_NAME');
139: fnd_message.raise_error;
140:
141: END IF;
139: fnd_message.raise_error;
140:
141: END IF;
142:
143: hr_utility.set_location('Leaving: '||l_proc, 30);
144:
145: END chk_accrual_plan_name;
146: --
147: -- ----------------------------------------------------------------------------
165: l_api_updating BOOLEAN;
166:
167: BEGIN
168:
169: hr_utility.set_location('Entering: '||l_proc, 10);
170:
171: --
172: -- Only proceed with validation if:
173: -- a) inserting or
198:
199: --
200: -- The accrual category does not exist in the lookup.
201: --
202: hr_utility.set_location(l_proc, 20);
203: fnd_message.set_name('PER', 'HR_289325_LEG_ACC_NOT_EXISTS');
204: fnd_message.raise_error;
205:
206: END IF;
204: fnd_message.raise_error;
205:
206: END IF;
207:
208: hr_utility.set_location('Leaving: '||l_proc, 90);
209:
210: END chk_accrual_category;
211: --
212: -- ----------------------------------------------------------------------------
230: l_api_updating BOOLEAN;
231:
232: BEGIN
233:
234: hr_utility.set_location('Entering: '||l_proc, 10);
235:
236: --
237: -- Only proceed with validation if:
238: -- a) inserting or
250: END IF;
251:
252: IF p_accrual_start IS NOT NULL THEN
253:
254: hr_utility.set_location(l_proc, 20);
255:
256: IF hr_api.not_exists_in_hr_lookups
257: (p_effective_date => p_effective_date
258: ,p_lookup_type => 'US_ACCRUAL_START_TYPE'
260:
261: --
262: -- The accrual start does not exist in the lookup.
263: --
264: hr_utility.set_location(l_proc, 30);
265: fnd_message.set_name('PER', 'HR_289814_PAP_START_INVALID');
266: fnd_message.raise_error;
267:
268: END IF;
268: END IF;
269:
270: END IF;
271:
272: hr_utility.set_location('Leaving: '||l_proc, 90);
273:
274: END chk_accrual_start;
275: --
276: -- ----------------------------------------------------------------------------
294: l_api_updating BOOLEAN;
295:
296: BEGIN
297:
298: hr_utility.set_location('Entering: '||l_proc, 10);
299:
300: hr_api.mandatory_arg_error(p_api_name => l_proc,
301: p_argument => 'p_accrual_units_of_measure',
302: p_argument_value => p_accrual_units_of_measure);
308:
309: --
310: -- The accrual UOM does not exist in the lookup.
311: --
312: hr_utility.set_location(l_proc, 20);
313: fnd_message.set_name('PER', 'HR_289815_PAP_UOM_INVALID');
314: fnd_message.raise_error;
315:
316: END IF;
314: fnd_message.raise_error;
315:
316: END IF;
317:
318: hr_utility.set_location('Leaving: '||l_proc, 90);
319:
320: END chk_accrual_units_of_measure;
321: --
322: -- ----------------------------------------------------------------------------
343: l_api_updating BOOLEAN;
344:
345: BEGIN
346:
347: hr_utility.set_location('Entering: '||l_proc, 10);
348:
349: --
350: -- Only proceed with validation if:
351: -- a) inserting or
365: hr_api.mandatory_arg_error(p_api_name => l_proc,
366: p_argument => 'p_accrual_formula_id',
367: p_argument_value => p_accrual_formula_id);
368:
369: hr_utility.set_location(l_proc, 20);
370:
371: l_accrual_formula := return_ff_name
372: (p_effective_date => p_effective_date
373: ,p_business_group_id => p_business_group_id
373: ,p_business_group_id => p_business_group_id
374: ,p_formula_id => p_accrual_formula_id
375: ,p_formula_type_name => 'Accrual');
376:
377: hr_utility.set_location(l_proc, 30);
378:
379: IF l_accrual_formula IS NULL THEN
380:
381: --
380:
381: --
382: -- The formula is not valid so error.
383: --
384: hr_utility.set_location(l_proc, 40);
385: fnd_message.set_name('PER', 'HR_289817_PAP_ACCRUAL_FF');
386: fnd_message.raise_error;
387:
388: END IF;
386: fnd_message.raise_error;
387:
388: END IF;
389:
390: hr_utility.set_location('Leaving: '||l_proc, 90);
391:
392: END chk_accrual_formula_id;
393: --
394: -- ----------------------------------------------------------------------------
417: l_api_updating BOOLEAN;
418:
419: BEGIN
420:
421: hr_utility.set_location('Entering: '||l_proc, 10);
422:
423: --
424: -- Only proceed with validation if:
425: -- a) inserting or
441: hr_api.mandatory_arg_error(p_api_name => l_proc,
442: p_argument => 'p_co_formula_id',
443: p_argument_value => p_co_formula_id);
444:
445: hr_utility.set_location(l_proc, 20);
446:
447: l_co_formula := return_ff_name
448: (p_effective_date => p_effective_date
449: ,p_business_group_id => p_business_group_id
454:
455: --
456: -- The formula is not valid so error.
457: --
458: hr_utility.set_location(l_proc, 30);
459: fnd_message.set_name('PER', 'HR_289817_PAP_ACCRUAL_FF');
460: fnd_message.raise_error;
461:
462: ELSIF l_co_formula IN ('PTO_PAYROLL_CARRYOVER'
468: -- This plan is using a seeded carry over formula,
469: -- get the accrual formula to check compatibility
470: -- (where possible).
471: --
472: hr_utility.set_location(l_proc, 40);
473:
474: --
475: -- First get the accrual formula.
476: -- This function call should always return a value because
482: ,p_business_group_id => p_business_group_id
483: ,p_formula_id => p_accrual_formula_id
484: ,p_formula_type_name => 'Accrual');
485:
486: hr_utility.set_location(l_proc, 50);
487:
488: IF l_accrual_formula IN ('PTO_PAYROLL_CALCULATION'
489: ,'PTO_PAYROLL_BALANCE_CALCULATION'
490: ,'PTO_SIMPLE_MULTIPLIER'
491: ,'PTO_SIMPLE_BALANCE_MULTIPLIER'
492: ,'PTO_HD_ANNIVERSARY_BALANCE'
493: ,'PTO_ROLLING_ACCRUAL') THEN
494:
495: hr_utility.set_location(l_proc, 60);
496: --
497: -- Seeded formula are being used for both the accrual and
498: -- carry over formulae. Check that the two are compatible.
499: --
507: l_accrual_formula <> 'PTO_HD_ANNIVERSARY_BALANCE')
508: OR (l_co_formula = 'PTO_ROLLING_CARRYOVER' AND
509: l_accrual_formula <> 'PTO_ROLLING_ACCRUAL') THEN
510:
511: hr_utility.set_location(l_proc, 70);
512: --
513: -- The carryover and accrual formulae are incompatible.
514: --
515: fnd_message.set_name('PER','HR_289819_PAP_FF_INCOMPATIBLE');
522: END IF;
523:
524: END IF;
525:
526: hr_utility.set_location('Leaving: '||l_proc, 90);
527:
528: END chk_co_formula_id;
529: --
530: -- ----------------------------------------------------------------------------
606: WHERE pbg.business_group_id = p_business_group_id;
607: --
608: BEGIN
609:
610: hr_utility.set_location('Entering: '||l_proc, 10);
611:
612: --
613: -- Only proceed with validation if:
614: -- a) inserting or
630: hr_api.mandatory_arg_error(p_api_name => l_proc,
631: p_argument => 'p_pto_input_value_id',
632: p_argument_value => p_pto_input_value_id);
633:
634: hr_utility.set_location(l_proc, 20);
635:
636: --
637: -- Fetch the legislation code
638: OPEN csr_get_leg_code;
646: CLOSE csr_chk_input_value;
647:
648: IF l_element_type_id IS NULL THEN
649:
650: hr_utility.set_location(l_proc, 20);
651: l_valid := FALSE;
652:
653: ELSE
654:
651: l_valid := FALSE;
652:
653: ELSE
654:
655: hr_utility.set_location(l_proc, 30);
656:
657: --
658: -- Check the element type and corresponding absence element.
659: --
661: FETCH csr_chk_pet_and_paat INTO l_dummy;
662:
663: IF csr_chk_pet_and_paat%NOTFOUND THEN
664:
665: hr_utility.set_location(l_proc, 40);
666: l_valid := FALSE;
667:
668: END IF;
669:
677: fnd_message.raise_error;
678:
679: END IF;
680:
681: hr_utility.set_location('Leaving: '||l_proc, 90);
682:
683: END chk_pto_input_value_id;
684: --
685: -- ----------------------------------------------------------------------------
741: WHERE pbg.business_group_id = p_business_group_id);
742:
743: BEGIN
744:
745: hr_utility.set_location('Entering: '||l_proc, 10);
746:
747: p_check_accrual_ff := FALSE;
748: --
749: -- Only proceed with validation if:
762: = NVL(p_defined_balance_id, hr_api.g_number)) THEN
763: RETURN;
764: END IF;
765:
766: hr_utility.set_location(l_proc, 20);
767:
768: IF p_defined_balance_id IS NOT NULL THEN
769:
770: hr_utility.set_location(l_proc, 30);
766: hr_utility.set_location(l_proc, 20);
767:
768: IF p_defined_balance_id IS NOT NULL THEN
769:
770: hr_utility.set_location(l_proc, 30);
771:
772: IF l_api_updating
773: AND NVL(pay_pap_shd.g_old_rec.defined_balance_id, hr_api.g_number)
774: <> hr_api.g_number THEN
776: --
777: -- The balance dimension has previously been set and is trying
778: -- to be updated. This is not allowed so error.
779: --
780: hr_utility.set_location(l_proc, 40);
781: fnd_message.set_name('PER','HR_289823_PAP_BAL_DIM_UPDATE');
782: fnd_message.raise_error;
783:
784:
783:
784:
785: END IF;
786:
787: hr_utility.set_location(l_proc, 50);
788:
789: --
790: -- Fetch the name of the accrual formula for later use. This
791: -- should never error or return null because the accrual formula
796: ,p_business_group_id => p_business_group_id
797: ,p_formula_id => p_accrual_formula_id
798: ,p_formula_type_name => 'Accrual');
799:
800: hr_utility.set_location(l_proc, 60);
801:
802: --
803: -- Fetch the balance dimension name.
804: --
805: OPEN csr_get_dim_name;
806: FETCH csr_get_dim_name INTO l_dimension_name;
807: CLOSE csr_get_dim_name;
808:
809: hr_utility.set_location(l_proc, 70);
810:
811: IF l_dimension_name IS NULL THEN
812:
813: --
815: -- balance has already been validated at this stage
816: -- so this would only occur when there is an internal
817: -- error with creating the defined balance).
818: --
819: hr_utility.set_location(l_proc, 80);
820: fnd_message.set_name('PER','HR_289820_PAP_DEF_BAL_INVALID');
821: fnd_message.raise_error;
822:
823: ELSIF l_dimension_name IN ('_ASG_PTO_SM_YTD'
830: --
831: -- This is a seed dimension name, check it is compatible
832: -- with the accrual formula.
833: --
834: hr_utility.set_location(l_proc, 90);
835:
836: IF (l_dimension_name IN ('_ASG_PTO_SM_YTD'
837: ,'_ASG_PTO_DE_SM_YTD') AND
838: l_accrual_formula IN ('PTO_PAYROLL_CALCULATION'
858: --
859: -- The balance dimension conflicts with the accrual
860: -- formula.
861: --
862: hr_utility.set_location(l_proc, 100);
863: fnd_message.set_name('PER', 'HR_289821_PAP_BAL_DIM_CONFLICT');
864: fnd_message.raise_error;
865:
866: END IF;
872: OPEN csr_get_bg_balance_type;
873: FETCH csr_get_bg_balance_type INTO l_balance_type;
874: CLOSE csr_get_bg_balance_type;
875:
876: hr_utility.set_location(l_proc, 110);
877:
878: IF l_balance_type IS NULL THEN
879: --
880: -- Check for a balance type at legislative level.
882: OPEN csr_get_leg_balance_type;
883: FETCH csr_get_leg_balance_type INTO l_balance_type;
884: CLOSE csr_get_leg_balance_type;
885:
886: hr_utility.set_location(l_proc, 120);
887:
888: END IF;
889:
890: IF (l_balance_type = 'DE' AND
895: l_dimension_name IN ('_ASG_PTO_DE_YTD'
896: ,'_ASG_PTO_DE_SM_YTD'
897: ,'_ASG_PTO_DE_HD_YTD')) THEN
898:
899: hr_utility.set_location(l_proc, 130);
900: fnd_message.set_name('PER', 'HR_289822_PAP_BAL_TYPE_DIM');
901: fnd_message.raise_error;
902:
903: END IF;
921: END IF;
922:
923: END IF;
924:
925: hr_utility.set_location('Leaving: '||l_proc, 140);
926:
927: END chk_defined_balance_id;
928: --
929: -- ----------------------------------------------------------------------------
948: l_api_updating BOOLEAN;
949:
950: BEGIN
951:
952: hr_utility.set_location('Entering: '||l_proc, 10);
953:
954: --
955: -- Only proceed with validation if:
956: -- a) inserting or
968: END IF;
969:
970: IF p_ineligible_period_type IS NOT NULL THEN
971:
972: hr_utility.set_location(l_proc, 20);
973:
974: IF hr_api.not_exists_in_hr_lookups
975: (p_effective_date => p_effective_date
976: ,p_lookup_type => 'PROC_PERIOD_TYPE'
978:
979: --
980: -- The ineligible period type does not exist in the lookup.
981: --
982: hr_utility.set_location(l_proc, 30);
983: fnd_message.set_name('PER', 'HR_289816_PAP_INELIG_INVALID');
984: fnd_message.raise_error;
985:
986: END IF;
986: END IF;
987:
988: END IF;
989:
990: hr_utility.set_location('Leaving: '||l_proc, 90);
991:
992: END chk_ineligible_period_type;
993: --
994: -- ----------------------------------------------------------------------------
1016: l_api_updating BOOLEAN;
1017:
1018: BEGIN
1019:
1020: hr_utility.set_location('Entering: '||l_proc, 10);
1021:
1022: --
1023: -- Only proceed with validation if:
1024: -- a) inserting or
1034: = NVL(p_ineligibility_formula_id, hr_api.g_number)) THEN
1035: RETURN;
1036: END IF;
1037:
1038: hr_utility.set_location(l_proc, 20);
1039:
1040: IF p_ineligibility_formula_id IS NOT NULL THEN
1041:
1042: hr_utility.set_location(l_proc, 30);
1038: hr_utility.set_location(l_proc, 20);
1039:
1040: IF p_ineligibility_formula_id IS NOT NULL THEN
1041:
1042: hr_utility.set_location(l_proc, 30);
1043: l_ineligible_formula := return_ff_name
1044: (p_effective_date => p_effective_date
1045: ,p_business_group_id => p_business_group_id
1046: ,p_formula_id => p_ineligibility_formula_id
1045: ,p_business_group_id => p_business_group_id
1046: ,p_formula_id => p_ineligibility_formula_id
1047: ,p_formula_type_name => 'Accrual Ineligibility');
1048:
1049: hr_utility.set_location(l_proc, 40);
1050:
1051: IF l_ineligible_formula IS NULL THEN
1052:
1053: --
1052:
1053: --
1054: -- The formula is not valid so error.
1055: --
1056: hr_utility.set_location(l_proc, 50);
1057: fnd_message.set_name('PER', 'HR_289818_PAP_INELIG_FF');
1058: fnd_message.raise_error;
1059:
1060: END IF;
1060: END IF;
1061:
1062: END IF;
1063:
1064: hr_utility.set_location('Leaving: '||l_proc, 90);
1065:
1066: END chk_ineligibility_formula_id;
1067: --
1068: -- ----------------------------------------------------------------------------
1099: --
1100: l_proc varchar2(72) := g_package || 'chk_ddf';
1101: --
1102: begin
1103: hr_utility.set_location('Entering:'||l_proc,10);
1104: --
1105: if ((p_rec.accrual_plan_id is not null) and (
1106: nvl(pay_pap_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1107: nvl(p_rec.information_category, hr_api.g_varchar2) or
1236: ,p_attribute30_name => 'INFORMATION30'
1237: );
1238: end if;
1239: --
1240: hr_utility.set_location(' Leaving:'||l_proc,20);
1241: end chk_ddf;
1242:
1243: --
1244: -- ----------------------------------------------------------------------------
1282: l_accrual_meaning varchar2(80);
1283: --
1284: Begin
1285: --
1286: hr_utility.set_location('Entering:'||l_proc, 5);
1287: --
1288: l_api_updating := pay_pap_shd.api_updating
1289: (p_accrual_plan_id => p_accrual_plan_id,
1290: p_object_version_number => p_object_version_number);
1328: fnd_message.set_name('PER','HR_289741_PAP_CHANGE_CATEGORY');
1329: fnd_message.raise_error;
1330: end if;
1331: end if;
1332: hr_utility.set_location('Leaving:'||l_proc, 100);
1333: --
1334: End chk_ddf_context;
1335: --
1336: -- ----------------------------------------------------------------------------
1345: l_proc varchar2(72) := g_package||'insert_validate';
1346:
1347: BEGIN
1348:
1349: hr_utility.set_location('Entering:'||l_proc, 10);
1350:
1351: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1352:
1353: --
1360: (p_accrual_plan_id => p_rec.accrual_plan_id
1361: ,p_accrual_plan_name => p_rec.accrual_plan_name
1362: ,p_business_group_id => p_rec.business_group_id);
1363:
1364: hr_utility.set_location(l_proc, 20);
1365:
1366: --
1367: -- Check the accrual category.
1368: --
1371: ,p_accrual_plan_id => p_rec.accrual_plan_id
1372: ,p_object_version_number => p_rec.object_version_number
1373: ,p_accrual_category => p_rec.accrual_category);
1374:
1375: hr_utility.set_location(l_proc, 30);
1376:
1377: --
1378: -- Check the accrual start.
1379: --
1382: ,p_accrual_plan_id => p_rec.accrual_plan_id
1383: ,p_object_version_number => p_rec.object_version_number
1384: ,p_accrual_start => p_rec.accrual_start);
1385:
1386: hr_utility.set_location(l_proc, 40);
1387:
1388: --
1389: -- Check the accrual UOM.
1390: --
1393: ,p_accrual_plan_id => p_rec.accrual_plan_id
1394: ,p_object_version_number => p_rec.object_version_number
1395: ,p_accrual_units_of_measure => p_rec.accrual_units_of_measure);
1396:
1397: hr_utility.set_location(l_proc, 50);
1398:
1399: --
1400: -- Check the accrual formula.
1401: --
1405: ,p_object_version_number => p_rec.object_version_number
1406: ,p_business_group_id => p_rec.business_group_id
1407: ,p_accrual_formula_id => p_rec.accrual_formula_id);
1408:
1409: hr_utility.set_location(l_proc, 60);
1410:
1411: --
1412: -- Check the carry over formula.
1413: --
1418: ,p_business_group_id => p_rec.business_group_id
1419: ,p_accrual_formula_id => p_rec.accrual_formula_id
1420: ,p_co_formula_id => p_rec.co_formula_id);
1421:
1422: hr_utility.set_location(l_proc, 70);
1423:
1424: --
1425: -- Check the absence element's input value
1426: --
1430: ,p_pto_input_value_id => p_rec.pto_input_value_id
1431: ,p_business_group_id => p_rec.business_group_id
1432: ,p_accrual_units_of_measure => p_rec.accrual_units_of_measure);
1433:
1434: hr_utility.set_location(l_proc, 80);
1435:
1436: --
1437: -- Check the defined balance.
1438: --
1444: ,p_accrual_formula_id => p_rec.accrual_formula_id
1445: ,p_defined_balance_id => p_rec.defined_balance_id
1446: ,p_check_accrual_ff => p_check_accrual_ff);
1447:
1448: hr_utility.set_location(l_proc, 90);
1449:
1450: --
1451: -- Check the ineligible period type.
1452: --
1455: ,p_accrual_plan_id => p_rec.accrual_plan_id
1456: ,p_object_version_number => p_rec.object_version_number
1457: ,p_ineligible_period_type => p_rec.ineligible_period_type);
1458:
1459: hr_utility.set_location(l_proc, 100);
1460:
1461: --
1462: -- Check the ineligibility formula.
1463: --
1467: ,p_object_version_number => p_rec.object_version_number
1468: ,p_business_group_id => p_rec.business_group_id
1469: ,p_ineligibility_formula_id => p_rec.ineligibility_formula_id);
1470:
1471: hr_utility.set_location(l_proc, 110);
1472:
1473: --
1474: -- Check the flexfields.
1475: --
1474: -- Check the flexfields.
1475: --
1476: pay_pap_bus.chk_ddf (p_rec);
1477:
1478: hr_utility.set_location(l_proc, 120);
1479:
1480: pay_pap_bus.chk_ddf_context
1481: (p_business_group_id => p_rec.business_group_id
1482: ,p_information_category => p_rec.information_category
1483: ,p_accrual_category => p_rec.accrual_category
1484: ,p_accrual_plan_id => p_rec.accrual_plan_id
1485: ,p_object_version_number => p_rec.object_version_number);
1486:
1487: hr_utility.set_location(' Leaving:'||l_proc, 130);
1488:
1489: END insert_validate;
1490: --
1491: -- ----------------------------------------------------------------------------
1500: l_proc varchar2(72) := g_package||'update_validate';
1501:
1502: BEGIN
1503:
1504: hr_utility.set_location('Entering:'||l_proc, 10);
1505:
1506: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1507:
1508: --
1508: --
1509: -- Call all supporting business operations
1510: --
1511:
1512: hr_utility.set_location(l_proc, 20);
1513:
1514: --
1515: -- Check the accrual category.
1516: --
1519: ,p_accrual_plan_id => p_rec.accrual_plan_id
1520: ,p_object_version_number => p_rec.object_version_number
1521: ,p_accrual_category => p_rec.accrual_category);
1522:
1523: hr_utility.set_location(l_proc, 30);
1524:
1525: --
1526: -- Check the accrual start.
1527: --
1530: ,p_accrual_plan_id => p_rec.accrual_plan_id
1531: ,p_object_version_number => p_rec.object_version_number
1532: ,p_accrual_start => p_rec.accrual_start);
1533:
1534: hr_utility.set_location(l_proc, 40);
1535:
1536: --
1537: -- Check the accrual formula.
1538: --
1542: ,p_object_version_number => p_rec.object_version_number
1543: ,p_business_group_id => p_rec.business_group_id
1544: ,p_accrual_formula_id => p_rec.accrual_formula_id);
1545:
1546: hr_utility.set_location(l_proc, 50);
1547:
1548: --
1549: -- Check the carry over formula.
1550: --
1555: ,p_business_group_id => p_rec.business_group_id
1556: ,p_accrual_formula_id => p_rec.accrual_formula_id
1557: ,p_co_formula_id => p_rec.co_formula_id);
1558:
1559: hr_utility.set_location(l_proc, 60);
1560:
1561: --
1562: -- Check the absence element's input value
1563: --
1567: ,p_pto_input_value_id => p_rec.pto_input_value_id
1568: ,p_business_group_id => p_rec.business_group_id
1569: ,p_accrual_units_of_measure => p_rec.accrual_units_of_measure);
1570:
1571: hr_utility.set_location(l_proc, 70);
1572:
1573: --
1574: -- Check the defined balance.
1575: --
1581: ,p_accrual_formula_id => p_rec.accrual_formula_id
1582: ,p_defined_balance_id => p_rec.defined_balance_id
1583: ,p_check_accrual_ff => p_check_accrual_ff);
1584:
1585: hr_utility.set_location(l_proc, 80);
1586:
1587: --
1588: -- Check the ineligible period type.
1589: --
1592: ,p_accrual_plan_id => p_rec.accrual_plan_id
1593: ,p_object_version_number => p_rec.object_version_number
1594: ,p_ineligible_period_type => p_rec.ineligible_period_type);
1595:
1596: hr_utility.set_location(l_proc, 90);
1597:
1598: --
1599: -- Check the ineligibility formula.
1600: --
1604: ,p_object_version_number => p_rec.object_version_number
1605: ,p_business_group_id => p_rec.business_group_id
1606: ,p_ineligibility_formula_id => p_rec.ineligibility_formula_id);
1607:
1608: hr_utility.set_location(l_proc, 100);
1609:
1610: --
1611: -- Check the flexfields.
1612: --
1611: -- Check the flexfields.
1612: --
1613: pay_pap_bus.chk_ddf (p_rec);
1614:
1615: hr_utility.set_location(l_proc, 110);
1616:
1617: pay_pap_bus.chk_ddf_context
1618: (p_business_group_id => p_rec.business_group_id
1619: ,p_information_category => p_rec.information_category
1620: ,p_accrual_category => p_rec.accrual_category
1621: ,p_accrual_plan_id => p_rec.accrual_plan_id
1622: ,p_object_version_number => p_rec.object_version_number);
1623:
1624: hr_utility.set_location(' Leaving:'||l_proc, 120);
1625:
1626: END update_validate;
1627: --
1628: -- ----------------------------------------------------------------------------
1632: --
1633: l_proc varchar2(72) := g_package||'delete_validate';
1634: --
1635: Begin
1636: hr_utility.set_location('Entering:'||l_proc, 5);
1637: --
1638: -- Call all supporting business operations
1639: --
1640: hr_utility.set_location(' Leaving:'||l_proc, 10);
1636: hr_utility.set_location('Entering:'||l_proc, 5);
1637: --
1638: -- Call all supporting business operations
1639: --
1640: hr_utility.set_location(' Leaving:'||l_proc, 10);
1641: End delete_validate;
1642: --
1643: --
1644: -- ---------------------------------------------------------------------------
1663: l_proc varchar2(72) := g_package||'return_legislation_code';
1664: --
1665: begin
1666: --
1667: hr_utility.set_location('Entering:'|| l_proc, 10);
1668: --
1669: -- Ensure that all the mandatory parameter are not null
1670: --
1671: hr_api.mandatory_arg_error(p_api_name => l_proc,
1688: end if;
1689: --
1690: close csr_leg_code;
1691: --
1692: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1693: --
1694: return l_legislation_code;
1695: --
1696: end return_legislation_code;
1718: --
1719: l_security_group_id number;
1720: l_proc varchar2(72) := g_package||'set_security_group_id';
1721: begin
1722: hr_utility.set_location('Entering:'|| l_proc, 10);
1723: --
1724: -- Ensure that all the mandatory parameter are not null
1725: --
1726: hr_api.mandatory_arg_error(p_api_name => l_proc,
1744: hr_api.set_security_group_id
1745: (p_security_group_id => l_security_group_id
1746: );
1747: --
1748: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1749: end set_security_group_id;
1750: --
1751: */
1752: end pay_pap_bus;