DBA Data[Home] [Help]

APPS.HR_CLE_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: fnd_message.raise_error;
65: --
66: end if;
67: close csr_sec_grp;

Line 64: fnd_message.raise_error;

60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: fnd_message.raise_error;
65: --
66: end if;
67: close csr_sec_grp;
68: --

Line 141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

137: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --

Line 142: fnd_message.raise_error;

138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
146: -- Set the global variables so the values are

Line 380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

376: (p_soc_ins_contr_lvls_id => p_rec.soc_ins_contr_lvls_id
377: ,p_effective_date => p_effective_date
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;

Line 381: fnd_message.set_token('PROCEDURE ', l_proc);

377: ,p_effective_date => p_effective_date
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385:

Line 382: fnd_message.set_token('STEP ', '5');

378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385:
386: IF nvl(p_rec.organization_id, hr_api.g_number) <>

Line 383: fnd_message.raise_error;

379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385:
386: IF nvl(p_rec.organization_id, hr_api.g_number) <>
387: nvl(hr_cle_shd.g_old_rec.organization_id,hr_api.g_number) THEN

Line 1066: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');

1062:
1063: IF ( P_NORMAL_PERCENTAGE IS NULL) then
1064: --
1065: hr_utility.set_location(l_proc, 30);
1066: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');
1067: fnd_message.set_token('COL_NAME','normal_percentage');
1068: fnd_message.raise_error;
1069:
1070: --

Line 1067: fnd_message.set_token('COL_NAME','normal_percentage');

1063: IF ( P_NORMAL_PERCENTAGE IS NULL) then
1064: --
1065: hr_utility.set_location(l_proc, 30);
1066: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');
1067: fnd_message.set_token('COL_NAME','normal_percentage');
1068: fnd_message.raise_error;
1069:
1070: --
1071: END IF;

Line 1068: fnd_message.raise_error;

1064: --
1065: hr_utility.set_location(l_proc, 30);
1066: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');
1067: fnd_message.set_token('COL_NAME','normal_percentage');
1068: fnd_message.raise_error;
1069:
1070: --
1071: END IF;
1072: --

Line 1139: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1135:
1136: IF ( P_INCREASED_PERCENTAGE IS NULL) then
1137: --
1138: hr_utility.set_location(l_proc, 30);
1139: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1140: fnd_message.set_token('COL_NAME','increased_percentage');
1141: fnd_message.raise_error;
1142: --
1143: END IF;

Line 1140: fnd_message.set_token('COL_NAME','increased_percentage');

1136: IF ( P_INCREASED_PERCENTAGE IS NULL) then
1137: --
1138: hr_utility.set_location(l_proc, 30);
1139: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1140: fnd_message.set_token('COL_NAME','increased_percentage');
1141: fnd_message.raise_error;
1142: --
1143: END IF;
1144:

Line 1141: fnd_message.raise_error;

1137: --
1138: hr_utility.set_location(l_proc, 30);
1139: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1140: fnd_message.set_token('COL_NAME','increased_percentage');
1141: fnd_message.raise_error;
1142: --
1143: END IF;
1144:
1145: END IF;

Line 1211: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1207:
1208: IF ( P_REDUCED_PERCENTAGE IS NULL ) then
1209: --
1210: hr_utility.set_location(l_proc, 30);
1211: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1212: fnd_message.set_token('COL_NAME','reduced_percentage');
1213: fnd_message.raise_error;
1214: --
1215: END IF;

Line 1212: fnd_message.set_token('COL_NAME','reduced_percentage');

1208: IF ( P_REDUCED_PERCENTAGE IS NULL ) then
1209: --
1210: hr_utility.set_location(l_proc, 30);
1211: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1212: fnd_message.set_token('COL_NAME','reduced_percentage');
1213: fnd_message.raise_error;
1214: --
1215: END IF;
1216: --

Line 1213: fnd_message.raise_error;

1209: --
1210: hr_utility.set_location(l_proc, 30);
1211: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1212: fnd_message.set_token('COL_NAME','reduced_percentage');
1213: fnd_message.raise_error;
1214: --
1215: END IF;
1216: --
1217: END IF;

Line 1281: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');

1277:
1278: IF ( p_max_increased_contribution IS NULL ) then
1279: --
1280: hr_utility.set_location(l_proc, 30);
1281: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');
1282: fnd_message.set_token('COL_NAME','max_increased_contribution');
1283: fnd_message.raise_error;
1284: --
1285: END IF;

Line 1282: fnd_message.set_token('COL_NAME','max_increased_contribution');

1278: IF ( p_max_increased_contribution IS NULL ) then
1279: --
1280: hr_utility.set_location(l_proc, 30);
1281: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');
1282: fnd_message.set_token('COL_NAME','max_increased_contribution');
1283: fnd_message.raise_error;
1284: --
1285: END IF;
1286: --

Line 1283: fnd_message.raise_error;

1279: --
1280: hr_utility.set_location(l_proc, 30);
1281: fnd_message.set_name('PER', 'HR_DE_COLUMN_NULL');
1282: fnd_message.set_token('COL_NAME','max_increased_contribution');
1283: fnd_message.raise_error;
1284: --
1285: END IF;
1286: --
1287: IF ( p_max_increased_contribution < 0 ) then

Line 1290: fnd_message.set_name('PER', 'HR_DE_COL_NEGATIVE');

1286: --
1287: IF ( p_max_increased_contribution < 0 ) then
1288: --
1289: hr_utility.set_location(l_proc, 30);
1290: fnd_message.set_name('PER', 'HR_DE_COL_NEGATIVE');
1291: fnd_message.set_token('COL_NAME','max_increased_contribution');
1292: fnd_message.raise_error;
1293: --
1294: END IF;

Line 1291: fnd_message.set_token('COL_NAME','max_increased_contribution');

1287: IF ( p_max_increased_contribution < 0 ) then
1288: --
1289: hr_utility.set_location(l_proc, 30);
1290: fnd_message.set_name('PER', 'HR_DE_COL_NEGATIVE');
1291: fnd_message.set_token('COL_NAME','max_increased_contribution');
1292: fnd_message.raise_error;
1293: --
1294: END IF;
1295: --

Line 1292: fnd_message.raise_error;

1288: --
1289: hr_utility.set_location(l_proc, 30);
1290: fnd_message.set_name('PER', 'HR_DE_COL_NEGATIVE');
1291: fnd_message.set_token('COL_NAME','max_increased_contribution');
1292: fnd_message.raise_error;
1293: --
1294: END IF;
1295: --
1296:

Line 1361: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1357:
1358: IF ( p_min_increased_contribution IS NULL ) then
1359: --
1360: hr_utility.set_location(l_proc, 30);
1361: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1362: fnd_message.set_token('COL_NAME','min_increased_contribution');
1363: fnd_message.raise_error;
1364: --
1365: END IF;

Line 1362: fnd_message.set_token('COL_NAME','min_increased_contribution');

1358: IF ( p_min_increased_contribution IS NULL ) then
1359: --
1360: hr_utility.set_location(l_proc, 30);
1361: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1362: fnd_message.set_token('COL_NAME','min_increased_contribution');
1363: fnd_message.raise_error;
1364: --
1365: END IF;
1366: --

Line 1363: fnd_message.raise_error;

1359: --
1360: hr_utility.set_location(l_proc, 30);
1361: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1362: fnd_message.set_token('COL_NAME','min_increased_contribution');
1363: fnd_message.raise_error;
1364: --
1365: END IF;
1366: --
1367: IF ( p_min_increased_contribution < 0 ) then

Line 1370: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

1366: --
1367: IF ( p_min_increased_contribution < 0 ) then
1368: --
1369: hr_utility.set_location(l_proc, 30);
1370: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1371: fnd_message.set_token('COL_NAME','min_increased_contribution');
1372: fnd_message.raise_error;
1373:
1374: END IF;

Line 1371: fnd_message.set_token('COL_NAME','min_increased_contribution');

1367: IF ( p_min_increased_contribution < 0 ) then
1368: --
1369: hr_utility.set_location(l_proc, 30);
1370: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1371: fnd_message.set_token('COL_NAME','min_increased_contribution');
1372: fnd_message.raise_error;
1373:
1374: END IF;
1375: --

Line 1372: fnd_message.raise_error;

1368: --
1369: hr_utility.set_location(l_proc, 30);
1370: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1371: fnd_message.set_token('COL_NAME','min_increased_contribution');
1372: fnd_message.raise_error;
1373:
1374: END IF;
1375: --
1376: END IF;

Line 1442: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1438:
1439: IF ( p_month1_min_contribution IS NULL ) then
1440: --
1441: hr_utility.set_location(l_proc, 30);
1442: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1443: fnd_message.set_token('COL_NAME','month1_min_contribution');
1444: fnd_message.raise_error;
1445: --
1446: END IF;

Line 1443: fnd_message.set_token('COL_NAME','month1_min_contribution');

1439: IF ( p_month1_min_contribution IS NULL ) then
1440: --
1441: hr_utility.set_location(l_proc, 30);
1442: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1443: fnd_message.set_token('COL_NAME','month1_min_contribution');
1444: fnd_message.raise_error;
1445: --
1446: END IF;
1447: --

Line 1444: fnd_message.raise_error;

1440: --
1441: hr_utility.set_location(l_proc, 30);
1442: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1443: fnd_message.set_token('COL_NAME','month1_min_contribution');
1444: fnd_message.raise_error;
1445: --
1446: END IF;
1447: --
1448: IF ( p_month1_min_contribution < 0 ) then

Line 1451: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

1447: --
1448: IF ( p_month1_min_contribution < 0 ) then
1449: --
1450: hr_utility.set_location(l_proc, 30);
1451: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1452: fnd_message.set_token('COL_NAME','month1_min_contribution');
1453: fnd_message.raise_error;
1454:
1455: END IF;

Line 1452: fnd_message.set_token('COL_NAME','month1_min_contribution');

1448: IF ( p_month1_min_contribution < 0 ) then
1449: --
1450: hr_utility.set_location(l_proc, 30);
1451: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1452: fnd_message.set_token('COL_NAME','month1_min_contribution');
1453: fnd_message.raise_error;
1454:
1455: END IF;
1456: --

Line 1453: fnd_message.raise_error;

1449: --
1450: hr_utility.set_location(l_proc, 30);
1451: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1452: fnd_message.set_token('COL_NAME','month1_min_contribution');
1453: fnd_message.raise_error;
1454:
1455: END IF;
1456: --
1457: END IF;

Line 1522: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1518:
1519: IF ( p_month1_max_contribution IS NULL ) then
1520: --
1521: hr_utility.set_location(l_proc, 30);
1522: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1523: fnd_message.set_token('COL_NAME','month1_max_contribution');
1524: fnd_message.raise_error;
1525: --
1526: END IF;

Line 1523: fnd_message.set_token('COL_NAME','month1_max_contribution');

1519: IF ( p_month1_max_contribution IS NULL ) then
1520: --
1521: hr_utility.set_location(l_proc, 30);
1522: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1523: fnd_message.set_token('COL_NAME','month1_max_contribution');
1524: fnd_message.raise_error;
1525: --
1526: END IF;
1527: --

Line 1524: fnd_message.raise_error;

1520: --
1521: hr_utility.set_location(l_proc, 30);
1522: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1523: fnd_message.set_token('COL_NAME','month1_max_contribution');
1524: fnd_message.raise_error;
1525: --
1526: END IF;
1527: --
1528: IF ( p_month1_max_contribution < 0 ) then

Line 1531: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

1527: --
1528: IF ( p_month1_max_contribution < 0 ) then
1529: --
1530: hr_utility.set_location(l_proc, 30);
1531: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1532: fnd_message.set_token('COL_NAME','month1_max_contribution');
1533: fnd_message.raise_error;
1534:
1535: END IF;

Line 1532: fnd_message.set_token('COL_NAME','month1_max_contribution');

1528: IF ( p_month1_max_contribution < 0 ) then
1529: --
1530: hr_utility.set_location(l_proc, 30);
1531: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1532: fnd_message.set_token('COL_NAME','month1_max_contribution');
1533: fnd_message.raise_error;
1534:
1535: END IF;
1536: --

Line 1533: fnd_message.raise_error;

1529: --
1530: hr_utility.set_location(l_proc, 30);
1531: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1532: fnd_message.set_token('COL_NAME','month1_max_contribution');
1533: fnd_message.raise_error;
1534:
1535: END IF;
1536: --
1537: END IF;

Line 1603: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1599:
1600: IF ( p_month2_min_contribution IS NULL ) then
1601: --
1602: hr_utility.set_location(l_proc, 30);
1603: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1604: fnd_message.set_token('COL_NAME','month2_min_contribution');
1605: fnd_message.raise_error;
1606: --
1607: END IF;

Line 1604: fnd_message.set_token('COL_NAME','month2_min_contribution');

1600: IF ( p_month2_min_contribution IS NULL ) then
1601: --
1602: hr_utility.set_location(l_proc, 30);
1603: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1604: fnd_message.set_token('COL_NAME','month2_min_contribution');
1605: fnd_message.raise_error;
1606: --
1607: END IF;
1608: --

Line 1605: fnd_message.raise_error;

1601: --
1602: hr_utility.set_location(l_proc, 30);
1603: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1604: fnd_message.set_token('COL_NAME','month2_min_contribution');
1605: fnd_message.raise_error;
1606: --
1607: END IF;
1608: --
1609: IF ( p_month2_min_contribution < 0 ) then

Line 1612: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

1608: --
1609: IF ( p_month2_min_contribution < 0 ) then
1610: --
1611: hr_utility.set_location(l_proc, 30);
1612: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1613: fnd_message.set_token('COL_NAME','month2_min_contribution');
1614: fnd_message.raise_error;
1615:
1616: END IF;

Line 1613: fnd_message.set_token('COL_NAME','month2_min_contribution');

1609: IF ( p_month2_min_contribution < 0 ) then
1610: --
1611: hr_utility.set_location(l_proc, 30);
1612: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1613: fnd_message.set_token('COL_NAME','month2_min_contribution');
1614: fnd_message.raise_error;
1615:
1616: END IF;
1617: --

Line 1614: fnd_message.raise_error;

1610: --
1611: hr_utility.set_location(l_proc, 30);
1612: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1613: fnd_message.set_token('COL_NAME','month2_min_contribution');
1614: fnd_message.raise_error;
1615:
1616: END IF;
1617: --
1618: END IF;

Line 1683: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');

1679:
1680: IF ( p_month2_max_contribution IS NULL ) then
1681: --
1682: hr_utility.set_location(l_proc, 30);
1683: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1684: fnd_message.set_token('COL_NAME','month2_max_contribution');
1685: fnd_message.raise_error;
1686: --
1687: END IF;

Line 1684: fnd_message.set_token('COL_NAME','month2_max_contribution');

1680: IF ( p_month2_max_contribution IS NULL ) then
1681: --
1682: hr_utility.set_location(l_proc, 30);
1683: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1684: fnd_message.set_token('COL_NAME','month2_max_contribution');
1685: fnd_message.raise_error;
1686: --
1687: END IF;
1688: --

Line 1685: fnd_message.raise_error;

1681: --
1682: hr_utility.set_location(l_proc, 30);
1683: FND_MESSAGE.set_name('PER', 'HR_DE_COLUMN_NULL');
1684: fnd_message.set_token('COL_NAME','month2_max_contribution');
1685: fnd_message.raise_error;
1686: --
1687: END IF;
1688: --
1689: IF ( p_month2_max_contribution < 0 ) then

Line 1692: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

1688: --
1689: IF ( p_month2_max_contribution < 0 ) then
1690: --
1691: hr_utility.set_location(l_proc, 30);
1692: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1693: fnd_message.set_token('COL_NAME','month2_max_contribution');
1694: fnd_message.raise_error;
1695:
1696: END IF;

Line 1693: fnd_message.set_token('COL_NAME','month2_max_contribution');

1689: IF ( p_month2_max_contribution < 0 ) then
1690: --
1691: hr_utility.set_location(l_proc, 30);
1692: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1693: fnd_message.set_token('COL_NAME','month2_max_contribution');
1694: fnd_message.raise_error;
1695:
1696: END IF;
1697: --

Line 1694: fnd_message.raise_error;

1690: --
1691: hr_utility.set_location(l_proc, 30);
1692: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
1693: fnd_message.set_token('COL_NAME','month2_max_contribution');
1694: fnd_message.raise_error;
1695:
1696: END IF;
1697: --
1698: END IF;

Line 2006: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

2002: --
2003: IF ( p_flat_tax_limit_per_month < 0 ) then
2004: --
2005: hr_utility.set_location(l_proc, 30);
2006: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
2007: fnd_message.set_token('COL_NAME','flat_tax_limit_per_month');
2008: fnd_message.raise_error;
2009:
2010: END IF;

Line 2007: fnd_message.set_token('COL_NAME','flat_tax_limit_per_month');

2003: IF ( p_flat_tax_limit_per_month < 0 ) then
2004: --
2005: hr_utility.set_location(l_proc, 30);
2006: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
2007: fnd_message.set_token('COL_NAME','flat_tax_limit_per_month');
2008: fnd_message.raise_error;
2009:
2010: END IF;
2011: --

Line 2008: fnd_message.raise_error;

2004: --
2005: hr_utility.set_location(l_proc, 30);
2006: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
2007: fnd_message.set_token('COL_NAME','flat_tax_limit_per_month');
2008: fnd_message.raise_error;
2009:
2010: END IF;
2011: --
2012: END IF;

Line 2078: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');

2074: --
2075: IF ( p_flat_tax_limit_per_year < 0 ) then
2076: --
2077: hr_utility.set_location(l_proc, 30);
2078: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
2079: fnd_message.set_token('COL_NAME','flat_tax_limit_per_year');
2080: fnd_message.raise_error;
2081:
2082: END IF;

Line 2079: fnd_message.set_token('COL_NAME','flat_tax_limit_per_year');

2075: IF ( p_flat_tax_limit_per_year < 0 ) then
2076: --
2077: hr_utility.set_location(l_proc, 30);
2078: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
2079: fnd_message.set_token('COL_NAME','flat_tax_limit_per_year');
2080: fnd_message.raise_error;
2081:
2082: END IF;
2083: --

Line 2080: fnd_message.raise_error;

2076: --
2077: hr_utility.set_location(l_proc, 30);
2078: FND_MESSAGE.set_name('PER', 'HR_DE_COL_NEGATIVE');
2079: fnd_message.set_token('COL_NAME','flat_tax_limit_per_year');
2080: fnd_message.raise_error;
2081:
2082: END IF;
2083: --
2084: END IF;

Line 2482: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

2478: --
2479: -- A referential integrity check was violated therefore
2480: -- we must error
2481: --
2482: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
2483: fnd_message.set_token('TABLE_NAME', l_table_name);
2484: fnd_message.raise_error;
2485: When Others Then
2486: --

Line 2483: fnd_message.set_token('TABLE_NAME', l_table_name);

2479: -- A referential integrity check was violated therefore
2480: -- we must error
2481: --
2482: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
2483: fnd_message.set_token('TABLE_NAME', l_table_name);
2484: fnd_message.raise_error;
2485: When Others Then
2486: --
2487: -- An unhandled or unexpected error has occurred which

Line 2484: fnd_message.raise_error;

2480: -- we must error
2481: --
2482: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
2483: fnd_message.set_token('TABLE_NAME', l_table_name);
2484: fnd_message.raise_error;
2485: When Others Then
2486: --
2487: -- An unhandled or unexpected error has occurred which
2488: -- we must report

Line 2490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2486: --
2487: -- An unhandled or unexpected error has occurred which
2488: -- we must report
2489: --
2490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2491: fnd_message.set_token('PROCEDURE', l_proc);
2492: fnd_message.set_token('STEP','15');
2493: fnd_message.raise_error;
2494: End dt_update_validate;

Line 2491: fnd_message.set_token('PROCEDURE', l_proc);

2487: -- An unhandled or unexpected error has occurred which
2488: -- we must report
2489: --
2490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2491: fnd_message.set_token('PROCEDURE', l_proc);
2492: fnd_message.set_token('STEP','15');
2493: fnd_message.raise_error;
2494: End dt_update_validate;
2495: --

Line 2492: fnd_message.set_token('STEP','15');

2488: -- we must report
2489: --
2490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2491: fnd_message.set_token('PROCEDURE', l_proc);
2492: fnd_message.set_token('STEP','15');
2493: fnd_message.raise_error;
2494: End dt_update_validate;
2495: --
2496: -- ----------------------------------------------------------------------------

Line 2493: fnd_message.raise_error;

2489: --
2490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2491: fnd_message.set_token('PROCEDURE', l_proc);
2492: fnd_message.set_token('STEP','15');
2493: fnd_message.raise_error;
2494: End dt_update_validate;
2495: --
2496: -- ----------------------------------------------------------------------------
2497: -- |--------------------------< dt_delete_validate >--------------------------|

Line 2589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

2585: --
2586: -- A referential integrity check was violated therefore
2587: -- we must error
2588: --
2589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
2590: fnd_message.set_token('TABLE_NAME', l_table_name);
2591: fnd_message.raise_error;
2592: When Others Then
2593: --

Line 2590: fnd_message.set_token('TABLE_NAME', l_table_name);

2586: -- A referential integrity check was violated therefore
2587: -- we must error
2588: --
2589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
2590: fnd_message.set_token('TABLE_NAME', l_table_name);
2591: fnd_message.raise_error;
2592: When Others Then
2593: --
2594: -- An unhandled or unexpected error has occurred which

Line 2591: fnd_message.raise_error;

2587: -- we must error
2588: --
2589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
2590: fnd_message.set_token('TABLE_NAME', l_table_name);
2591: fnd_message.raise_error;
2592: When Others Then
2593: --
2594: -- An unhandled or unexpected error has occurred which
2595: -- we must report

Line 2597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2593: --
2594: -- An unhandled or unexpected error has occurred which
2595: -- we must report
2596: --
2597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2598: fnd_message.set_token('PROCEDURE', l_proc);
2599: fnd_message.set_token('STEP','15');
2600: fnd_message.raise_error;
2601: --

Line 2598: fnd_message.set_token('PROCEDURE', l_proc);

2594: -- An unhandled or unexpected error has occurred which
2595: -- we must report
2596: --
2597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2598: fnd_message.set_token('PROCEDURE', l_proc);
2599: fnd_message.set_token('STEP','15');
2600: fnd_message.raise_error;
2601: --
2602: End dt_delete_validate;

Line 2599: fnd_message.set_token('STEP','15');

2595: -- we must report
2596: --
2597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2598: fnd_message.set_token('PROCEDURE', l_proc);
2599: fnd_message.set_token('STEP','15');
2600: fnd_message.raise_error;
2601: --
2602: End dt_delete_validate;
2603: --

Line 2600: fnd_message.raise_error;

2596: --
2597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2598: fnd_message.set_token('PROCEDURE', l_proc);
2599: fnd_message.set_token('STEP','15');
2600: fnd_message.raise_error;
2601: --
2602: End dt_delete_validate;
2603: --
2604: -- ----------------------------------------------------------------------------