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;
142:
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;
142:
143: hr_utility.set_location('Leaving: '||l_proc, 30);
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;
207:
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;
207:
208: hr_utility.set_location('Leaving: '||l_proc, 90);
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;
269:
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;
269:
270: END IF;
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;
317:
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;
317:
318: hr_utility.set_location('Leaving: '||l_proc, 90);
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;
389:
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;
389:
390: hr_utility.set_location('Leaving: '||l_proc, 90);
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'
463: ,'PTO_SIMPLE_CARRYOVER'
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'
463: ,'PTO_SIMPLE_CARRYOVER'
464: ,'PTO_ROLLING_CARRYOVER'
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');
516: fnd_message.set_token('CO_FF', l_co_formula);
517: fnd_message.set_token('ACCRUAL_FF', l_accrual_formula);
518: fnd_message.raise_error;
519:
512: --
513: -- The carryover and accrual formulae are incompatible.
514: --
515: fnd_message.set_name('PER','HR_289819_PAP_FF_INCOMPATIBLE');
516: fnd_message.set_token('CO_FF', l_co_formula);
517: fnd_message.set_token('ACCRUAL_FF', l_accrual_formula);
518: fnd_message.raise_error;
519:
520: END IF;
513: -- The carryover and accrual formulae are incompatible.
514: --
515: fnd_message.set_name('PER','HR_289819_PAP_FF_INCOMPATIBLE');
516: fnd_message.set_token('CO_FF', l_co_formula);
517: fnd_message.set_token('ACCRUAL_FF', l_accrual_formula);
518: fnd_message.raise_error;
519:
520: END IF;
521:
514: --
515: fnd_message.set_name('PER','HR_289819_PAP_FF_INCOMPATIBLE');
516: fnd_message.set_token('CO_FF', l_co_formula);
517: fnd_message.set_token('ACCRUAL_FF', l_accrual_formula);
518: fnd_message.raise_error;
519:
520: END IF;
521:
522: END IF;
672: CLOSE csr_chk_pet_and_paat;
673:
674: IF NOT l_valid THEN
675:
676: fnd_message.set_name('PER','HR_289813_PAP_INVALID_INPT_VAL');
677: fnd_message.raise_error;
678:
679: END IF;
680:
673:
674: IF NOT l_valid THEN
675:
676: fnd_message.set_name('PER','HR_289813_PAP_INVALID_INPT_VAL');
677: fnd_message.raise_error;
678:
679: END IF;
680:
681: hr_utility.set_location('Leaving: '||l_proc, 90);
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:
785: END IF;
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:
785: END IF;
786:
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'
824: ,'_ASG_PTO_DE_SM_YTD'
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'
824: ,'_ASG_PTO_DE_SM_YTD'
825: ,'_ASG_PTO_YTD'
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;
867:
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;
867:
868: --
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;
904:
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;
904:
905: END IF;
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;
987:
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;
987:
988: END IF;
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;
1061:
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;
1061:
1062: END IF;
1316: OR
1317: (p_information_category is not null and l_legislation_code ||'_'||
1318: p_accrual_category <> p_information_category)
1319: then
1320: fnd_message.set_name('PER','HR_289740_PAP_BAD_INFO_CONTEXT');
1321: fnd_message.raise_error;
1322: end if;
1323: -- error if accrual category is changing and ddf is already used.
1324: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1317: (p_information_category is not null and l_legislation_code ||'_'||
1318: p_accrual_category <> p_information_category)
1319: then
1320: fnd_message.set_name('PER','HR_289740_PAP_BAD_INFO_CONTEXT');
1321: fnd_message.raise_error;
1322: end if;
1323: -- error if accrual category is changing and ddf is already used.
1324: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1324: if (l_api_updating and nvl(p_accrual_category, hr_api.g_varchar2)
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: and pay_pap_shd.g_old_rec.information_category is not null )
1327: then
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);
1325: <> nvl(pay_pap_shd.g_old_rec.accrual_category, hr_api.g_varchar2)
1326: and pay_pap_shd.g_old_rec.information_category is not null )
1327: then
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: --
1681: close csr_leg_code;
1682: --
1683: -- The primary key is invalid therefore we must error
1684: --
1685: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1686: fnd_message.raise_error;
1687: --
1688: end if;
1689: --
1682: --
1683: -- The primary key is invalid therefore we must error
1684: --
1685: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1686: fnd_message.raise_error;
1687: --
1688: end if;
1689: --
1690: close csr_leg_code;
1733: close csr_sec_grp;
1734: --
1735: -- The primary key is invalid therefore we must error
1736: --
1737: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1738: fnd_message.raise_error;
1739: end if;
1740: close csr_sec_grp;
1741: --
1734: --
1735: -- The primary key is invalid therefore we must error
1736: --
1737: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1738: fnd_message.raise_error;
1739: end if;
1740: close csr_sec_grp;
1741: --
1742: -- Set the security_group_id in CLIENT_INFO