[Home] [Help]
45: l_api_updating boolean;
46: --
47: Begin
48: --
49: hr_utility.set_location('Entering:'||l_proc, 5);
50: --
51: l_api_updating := per_ssl_shd.api_updating
52: (p_salary_survey_line_id => p_salary_survey_line_id,
53: p_object_version_number => p_object_version_number);
75: End If;
76: --
77: End If;
78: --
79: hr_utility.set_location('Leaving:'||l_proc, 10);
80: --
81: End chk_salary_survey_line_id;
82: --
83: -- ----------------------------------------------------------------------------
121: where pss.salary_survey_id = p_salary_survey_id;
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: -- Check mandatory parameters have been set
128: --
129: hr_api.mandatory_arg_error
131: ,p_argument => 'salary_survey_id'
132: ,p_argument_value => p_salary_survey_id
133: );
134: --
135: hr_utility.set_location(l_proc,6);
136: --
137: --
138: -- check If salary_survey_id value exists in per_salary_surveys table
139: --
143: --
144: If csr_chk_survey_exists%notfound Then
145: --
146: close csr_chk_survey_exists;
147: hr_utility.set_location('SS id '||to_char(p_salary_survey_id),7);
148: --
149: -- raise error as FK does not relate to PK in per_salary_surveys
150: -- table.
151: --
154: End If;
155: --
156: close csr_chk_survey_exists;
157: --
158: hr_utility.set_location('Leaving:'||l_proc,10);
159: --
160: End chk_salary_survey_id;
161: --
162: --
280: and salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);
281: --
282: Begin
283: --
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- Check that start_date is not null. Error If it is.
287: --
288: If p_start_date is null Then
289: fnd_message.set_name('PER','PER_50341_SSL_MAND_START_DATE');
290: fnd_message.raise_error;
291: End If;
292: --
293: hr_utility.set_location(l_proc, 10);
294: --
295: -- Only proceed with validation If:
296: -- The current g_old_rec is current and
297: -- Any of the values have changed or
301: (p_salary_survey_line_id => p_salary_survey_line_id
302: ,p_object_version_number => p_object_version_number
303: );
304: --
305: hr_utility.set_location(l_proc, 15);
306: --
307: If (l_api_updating
308: and nvl(per_ssl_shd.g_old_rec.survey_job_name_code,hr_api.g_varchar2)
309: <> nvl(p_survey_job_name_code,hr_api.g_varchar2))
338: or
339: (NOT l_api_updating))
340: Then
341: --
342: hr_utility.set_location(l_proc, 17);
343: --
344: -- Check If this key already exists on this start date.
345: -- Error If it does.
346: --
361: --
362: -- Check that their is no overlap in the dates
363: -- with this key. Error If their is.
364: --
365: hr_utility.set_location(l_proc, 20);
366: --
367: open csr_overlap_date;
368: --
369: fetch csr_overlap_date into l_exists;
379: End If;
380: --
381: close csr_overlap_date;
382: --
383: hr_utility.set_location(l_proc, 25);
384: --
385: --
386: -- Check that the end_date does not fall within the start_date and end_date
387: -- of another survey_line when its accompanying keys match the keys of that
404: close csr_invalid_end_date;
405: --
406: End If;
407: --
408: hr_utility.set_location('Leaving:'||l_proc, 40);
409: --
410: End chk_unique_key;
411: --
412: --
476: and identifier = SUBSTR(p_survey_job_name_code,0,2);
477: --
478: Begin
479: --
480: hr_utility.set_location('Entering:'|| l_proc, 10);
481: --
482: -- Check mandatory parameters have been set
483: --
484: hr_api.mandatory_arg_error
493: fnd_message.set_name('PER','PER_50343_SSL_MAND_JOB_NAME');
494: fnd_message.raise_error;
495: End If;
496: --
497: hr_utility.set_location(l_proc, 13);
498: --
499: -- Only proceed with validation If:
500: -- a) During update, the value has actually changed to
501: -- another not null value.
512: p_survey_job_name_code))
513: or
514: (p_salary_survey_line_id is null)) Then
515: --
516: hr_utility.set_location(l_proc, 20);
517: --
518: -- Check If the survey_job_name_code value exists
519: -- in hr_standard_lookups where the lookup_type is 'SURVEY_JOB_NAME'
520: --
529: fnd_message.raise_error;
530: --
531: End If;
532: --
533: hr_utility.set_location(l_proc, 30);
534: --
535: -- Open the cursor to see If the job_name_code has the identifier
536: -- as the first two characters.
537: --
553: End If;
554: --
555: close csr_has_identifier;
556: --
557: hr_utility.set_location(l_proc, 35);
558: --
559: End If;
560: --
561: hr_utility.set_location(' Leaving:'|| l_proc, 40);
557: hr_utility.set_location(l_proc, 35);
558: --
559: End If;
560: --
561: hr_utility.set_location(' Leaving:'|| l_proc, 40);
562: --
563: End chk_survey_job_name_code;
564: --
565: --
625: and identifier = SUBSTR(p_survey_region_code,0,2);
626: --
627: --
628: Begin
629: hr_utility.set_location('Entering:'|| l_proc, 10);
630: --
631: -- Check mandatory parameters have been set
632: --
633: hr_api.mandatory_arg_error
635: ,p_argument => 'effective date'
636: ,p_argument_value => p_effective_date
637: );
638: --
639: hr_utility.set_location(l_proc, 13);
640: --
641: -- Only proceed with validation If:
642: -- a) During update, the value has actually changed to
643: -- another not null value.
656: <> nvl(p_survey_region_code,hr_api.g_varchar2)))
657: or
658: (p_salary_survey_line_id is null) ) Then
659: --
660: hr_utility.set_location(l_proc, 20);
661: --
662: -- Check If the survey_region_code value exists
663: -- in hr_standard_lookups where the lookup_type is 'SURVEY_REGION'
664: --
675: End If;
676: --
677: End If;
678: --
679: hr_utility.set_location(l_proc, 30);
680: --
681: -- Open the cursor to see If the survey_region_code has the
682: -- identifier as the first two characters.
683: --
699: End If;
700: --
701: close csr_has_identifier;
702: --
703: hr_utility.set_location(l_proc, 35);
704: --
705: End If;
706: --
707: hr_utility.set_location(' Leaving:'|| l_proc, 40);
703: hr_utility.set_location(l_proc, 35);
704: --
705: End If;
706: --
707: hr_utility.set_location(' Leaving:'|| l_proc, 40);
708: --
709: End chk_survey_region_code;
710: --
711: --
771: and identifier = SUBSTR(p_survey_seniority_code,0,2);
772: --
773: --
774: Begin
775: hr_utility.set_location('Entering:'|| l_proc, 10);
776: --
777: -- Check mandatory parameters have been set
778: --
779: hr_api.mandatory_arg_error
781: ,p_argument => 'effective date'
782: ,p_argument_value => p_effective_date
783: );
784: --
785: hr_utility.set_location(l_proc, 13);
786: --
787: -- Only proceed with validation If:
788: -- a) During update, the value has actually changed to
789: -- another not null value.
802: nvl(p_survey_seniority_code,hr_api.g_varchar2)))
803: or
804: (p_salary_survey_line_id is null)) Then
805: --
806: hr_utility.set_location(l_proc, 20);
807: --
808: -- Check If the survey_seniority_code value exists
809: -- in hr_standard_lookups where the lookup_type is 'SURVEY_SENIORITY'
810: --
821: End If;
822: --
823: End If;
824: --
825: hr_utility.set_location(l_proc, 30);
826: --
827: -- Open the cursor to see If the survey_seniority_code has the
828: -- identifier as the first two characters.
829: --
844: End If;
845: --
846: close csr_has_identifier;
847: --
848: hr_utility.set_location(l_proc, 35);
849: --
850: End If;
851: --
852: hr_utility.set_location(' Leaving:'|| l_proc, 40);
848: hr_utility.set_location(l_proc, 35);
849: --
850: End If;
851: --
852: hr_utility.set_location(' Leaving:'|| l_proc, 40);
853: --
854: End chk_survey_seniority_code;
855: --
856: --
916: and identifier = SUBSTR(p_company_size_code,0,2);
917: --
918: --
919: Begin
920: hr_utility.set_location('Entering:'|| l_proc, 10);
921: --
922: -- Check mandatory parameters have been set
923: --
924: hr_api.mandatory_arg_error
926: ,p_argument => 'effective date'
927: ,p_argument_value => p_effective_date
928: );
929: --
930: hr_utility.set_location(l_proc, 13);
931: --
932: -- Only proceed with validation If:
933: -- a) During update, the value has actually changed to
934: -- another not null value.
947: nvl(p_company_size_code,hr_api.g_varchar2)))
948: or
949: (p_salary_survey_line_id is null)) Then
950: --
951: hr_utility.set_location(l_proc, 20);
952: --
953: -- Check If the company_size_code value exists
954: -- in hr_standard_lookups where the lookup_type is 'COMPANY_SIZE'
955: --
966: End If;
967: --
968: End If;
969: --
970: hr_utility.set_location(l_proc, 30);
971: --
972: -- Open the cursor to see If the company_size_code has the
973: -- identifier as the first two characters.
974: --
989: End If;
990: --
991: close csr_has_identifier;
992: --
993: hr_utility.set_location(l_proc, 35);
994: --
995: End If;
996: --
997: hr_utility.set_location(' Leaving:'|| l_proc, 40);
993: hr_utility.set_location(l_proc, 35);
994: --
995: End If;
996: --
997: hr_utility.set_location(' Leaving:'|| l_proc, 40);
998: --
999: End chk_company_size_code;
1000: --
1001: --
1062: --
1063: --
1064: Begin
1065: --
1066: hr_utility.set_location('Entering:'|| l_proc, 10);
1067: --
1068: -- Check mandatory parameters have been set
1069: --
1070: hr_api.mandatory_arg_error
1072: ,p_argument => 'effective date'
1073: ,p_argument_value => p_effective_date
1074: );
1075: --
1076: hr_utility.set_location(l_proc, 13);
1077: --
1078: -- Only proceed with validation If:
1079: -- a) During update, the value has actually changed to
1080: -- another not null value.
1094: nvl(p_industry_code,hr_api.g_varchar2)))
1095: or
1096: (p_salary_survey_line_id is null)) Then
1097: --
1098: hr_utility.set_location(l_proc, 20);
1099: --
1100: -- Check If the industry_code value exists
1101: -- in hr_standard_lookups where the lookup_type is 'INDUSTRY'
1102: --
1113: End If;
1114: --
1115: End If;
1116: --
1117: hr_utility.set_location(l_proc, 30);
1118: --
1119: -- Open the cursor to see If the industry_code has the
1120: -- identifier as the first two characters.
1121: --
1137: End If;
1138: --
1139: close csr_has_identifier;
1140: --
1141: hr_utility.set_location(l_proc, 35);
1142: --
1143: End If;
1144: --
1145: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1141: hr_utility.set_location(l_proc, 35);
1142: --
1143: End If;
1144: --
1145: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1146: --
1147: End chk_industry_code;
1148:
1149: --
1211: --
1212: --
1213: Begin
1214: --
1215: hr_utility.set_location('Entering:'|| l_proc, 10);
1216: --
1217: -- Check mandatory parameters have been set
1218: --
1219: hr_api.mandatory_arg_error
1221: ,p_argument => 'effective date'
1222: ,p_argument_value => p_effective_date
1223: );
1224: --
1225: hr_utility.set_location(l_proc, 13);
1226: --
1227: -- Only proceed with validation If:
1228: -- a) During update, the value has actually changed to
1229: -- another not null value.
1243: nvl(p_survey_age_code,hr_api.g_varchar2)))
1244: or
1245: (p_salary_survey_line_id is null)) Then
1246: --
1247: hr_utility.set_location(l_proc, 20);
1248: --
1249: -- Check If the survey_age_code value exists
1250: -- in hr_standard_lookups where the lookup_type is 'SURVEY_AGE'
1251: --
1262: End If;
1263: --
1264: End If;
1265: --
1266: hr_utility.set_location(l_proc, 30);
1267: --
1268: -- Open the cursor to see If the survey_age_code has the
1269: -- identifier as the first two characters.
1270: --
1286: End If;
1287: --
1288: close csr_has_identifier;
1289: --
1290: hr_utility.set_location(l_proc, 35);
1291: --
1292: End If;
1293: --
1294: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1290: hr_utility.set_location(l_proc, 35);
1291: --
1292: End If;
1293: --
1294: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1295: --
1296: End chk_survey_age_code;
1297: --
1298: --
1346: --
1347:
1348: Begin
1349: --
1350: hr_utility.set_location('Entering:'|| l_proc, 10);
1351: --
1352: -- Check mandatory parameters have been set
1353: --
1354: hr_api.mandatory_arg_error
1356: ,p_argument => 'effective date'
1357: ,p_argument_value => p_effective_date
1358: );
1359: --
1360: hr_utility.set_location(l_proc, 13);
1361: --
1362: -- Only proceed with validation If:
1363: -- a) During update, the value has actually changed to
1364: -- another not null value.
1378: p_stock_display_type_code))
1379: or
1380: (p_salary_survey_line_id is null)) Then
1381: --
1382: hr_utility.set_location(l_proc, 20);
1383: --
1384: -- Check If the stock_display_type_code value exists
1385: -- in hr_standard_lookups where the lookup_type is 'STOCK_DISPLAY_TYPE'
1386: --
1395: fnd_message.raise_error;
1396: --
1397: End If;
1398: --
1399: hr_utility.set_location(l_proc, 30);
1400: End If;
1401: End If; -- p_stock_display_type_code is not null
1402: --
1403: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1399: hr_utility.set_location(l_proc, 30);
1400: End If;
1401: End If; -- p_stock_display_type_code is not null
1402: --
1403: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1404: --
1405: End chk_stock_display_type_code;
1406: --
1407: --
1448: l_proc varchar2(72) := g_package||'is_null';
1449:
1450: Begin
1451: --
1452: hr_utility.set_location('Entering:'||l_proc, 5);
1453: --
1454: If (p_value is not null) Then
1455: --
1456: -- Set flag to show that this value is not null.
1456: -- Set flag to show that this value is not null.
1457: --
1458: p_null_flag := false;
1459: --
1460: hr_utility.set_location(l_proc, 10);
1461: --
1462: End If;
1463: --
1464: hr_utility.set_location(l_proc, 20);
1460: hr_utility.set_location(l_proc, 10);
1461: --
1462: End If;
1463: --
1464: hr_utility.set_location(l_proc, 20);
1465: --
1466: End is_null;
1467: --
1468: -- ---------------------------------------------------------------
1610: (not l_api_updating) )
1611: then
1612:
1613: --
1614: hr_utility.set_location('Entering:'||l_proc, 5);
1615: --
1616: -- Check that at least one of the salary figures is not null.
1617: --
1618: -- Check Minimum Pay.
1619: --
1620: is_null(p_value => p_minimum_pay,
1621: p_null_flag => l_all_null);
1622: --
1623: hr_utility.set_location(l_proc, 10);
1624: --
1625: --
1626: -- Check Maximum Pay.
1627: --
1627: --
1628: is_null(p_value => p_maximum_pay,
1629: p_null_flag => l_all_null);
1630: --
1631: hr_utility.set_location(l_proc, 15);
1632: --
1633: --
1634: -- Check Mean pay
1635: --
1635: --
1636: is_null(p_value => p_mean_pay,
1637: p_null_flag => l_all_null);
1638: --
1639: hr_utility.set_location(l_proc, 20);
1640: --
1641: --
1642: -- Check Graduate pay
1643: --
1643: --
1644: is_null(p_value => p_graduate_pay,
1645: p_null_flag => l_all_null);
1646: --
1647: hr_utility.set_location(l_proc, 25);
1648: --
1649: --
1650: -- Check Starting pay
1651: --
1651: --
1652: is_null(p_value => p_starting_pay,
1653: p_null_flag => l_all_null);
1654: --
1655: hr_utility.set_location(l_proc, 30);
1656: --
1657: --
1658: -- Check Percentage Change
1659: --
1665: --
1666: is_null(p_value => p_job_first_quartile,
1667: p_null_flag => l_all_null);
1668: --
1669: hr_utility.set_location(l_proc, 35);
1670: --
1671: --
1672: -- Check job_median_quartile
1673: --
1673: --
1674: is_null(p_value => p_job_median_quartile,
1675: p_null_flag => l_all_null);
1676: --
1677: hr_utility.set_location(l_proc, 40);
1678: --
1679: --
1680: -- Check job_third_quartile
1681: --
1681: --
1682: is_null(p_value => p_job_third_quartile,
1683: p_null_flag => l_all_null);
1684: --
1685: hr_utility.set_location(l_proc, 45);
1686: --
1687: --
1688: -- Check job_fourth_quartile
1689: --
1689: --
1690: is_null(p_value => p_job_fourth_quartile,
1691: p_null_flag => l_all_null);
1692: --
1693: hr_utility.set_location(l_proc, 50);
1694: --
1695: --
1696: -- Check minimum_total_compensation
1697: --
1697: --
1698: is_null(p_value => p_minimum_total_compensation,
1699: p_null_flag => l_all_null);
1700: --
1701: hr_utility.set_location(l_proc, 55);
1702: --
1703: --
1704: -- Check mean_total_compensation
1705: --
1705: --
1706: is_null(p_value => p_mean_total_compensation,
1707: p_null_flag => l_all_null);
1708: --
1709: hr_utility.set_location(l_proc, 60);
1710: --
1711: --
1712: -- Check maximum_total_compensation
1713: --
1713: --
1714: is_null(p_value => p_maximum_total_compensation,
1715: p_null_flag => l_all_null);
1716: --
1717: hr_utility.set_location(l_proc, 65);
1718: --
1719: --
1720: -- Check compnstn_first_quartile
1721: --
1721: --
1722: is_null(p_value => p_compnstn_first_quartile,
1723: p_null_flag => l_all_null);
1724: --
1725: hr_utility.set_location(l_proc, 70);
1726: --
1727: --
1728: -- Check compnstn_median_quartile
1729: --
1729: --
1730: is_null(p_value => p_compnstn_median_quartile,
1731: p_null_flag => l_all_null);
1732: --
1733: hr_utility.set_location(l_proc, 80);
1734: --
1735: --
1736: -- Check compnstn_third_quartile
1737: --
1737: --
1738: is_null(p_value => p_compnstn_third_quartile,
1739: p_null_flag => l_all_null);
1740: --
1741: hr_utility.set_location(l_proc, 85);
1742: --
1743: --
1744: -- Check compnstn_fourth_quartile
1745: --
1745: --
1746: is_null(p_value => p_compnstn_fourth_quartile,
1747: p_null_flag => l_all_null);
1748: --
1749: hr_utility.set_location(l_proc, 90);
1750: --
1751: --
1752: -- If all the Salary Figures were null then raise an error;
1753: --
1760: End If;
1761: --
1762: End if;
1763: --
1764: hr_utility.set_location('Leaving:'||l_proc, 100);
1765: --
1766: End chk_salary_figures;
1767:
1768: --
1810: l_eot date := hr_general.End_of_time;
1811: --
1812: Begin
1813: --
1814: hr_utility.set_location('Entering:'||l_proc, 5);
1815: --
1816: -- Check that start_date is not null. Error If it is.
1817: --
1818: If p_start_date is null Then
1819: fnd_message.set_name('PER','PER_50374_SSL_MAND_START_DATE');
1820: fnd_message.raise_error;
1821: End If;
1822: --
1823: hr_utility.set_location(l_proc, 10);
1824: --
1825: -- Only proceed with validation If:
1826: -- The current g_old_rec is current and
1827: -- start_date has changed or
1827: -- start_date has changed or
1828: -- A record is being inserted
1829: --
1830: --
1831: hr_utility.set_location(l_proc, 15);
1832: --
1833: If
1834: (p_salary_survey_line_id is not null)
1835: and
1848: fnd_message.raise_error;
1849: --
1850: End If;
1851: --
1852: hr_utility.set_location(l_proc, 25);
1853: --
1854: End If;
1855: --
1856: hr_utility.set_location('Leaving:'||l_proc, 40);
1852: hr_utility.set_location(l_proc, 25);
1853: --
1854: End If;
1855: --
1856: hr_utility.set_location('Leaving:'||l_proc, 40);
1857: --
1858: End chk_dates;
1859: --
1860:
1906: from fnd_currencies_vl fcv
1907: where fcv.currency_code = p_currency_code;
1908: --
1909: begin
1910: hr_utility.set_location('Entering:'|| l_proc, 10);
1911: hr_utility.set_location(l_proc, 15);
1912: --
1913: -- Check that currency_code is not null
1914: --
1907: where fcv.currency_code = p_currency_code;
1908: --
1909: begin
1910: hr_utility.set_location('Entering:'|| l_proc, 10);
1911: hr_utility.set_location(l_proc, 15);
1912: --
1913: -- Check that currency_code is not null
1914: --
1915: if p_currency_code is null then
1916: fnd_message.set_name('PER','PER_50335_PSS_MAND_CURRENCY');
1917: fnd_message.raise_error;
1918: end if;
1919: --
1920: hr_utility.set_location(l_proc, 17);
1921: --
1922: -- Only proceed with validation if:
1923: -- a) During update, the value has actually changed to
1924: -- another not null value.
1930: hr_api.g_varchar2))
1931: or
1932: (p_salary_survey_line_id is null)) then
1933: --
1934: hr_utility.set_location(l_proc, 20);
1935: --
1936: -- If currency_code is not null then
1937: -- Check if the currency_code value exists
1938: -- in fnd_currencies_vl.
1950: fnd_message.raise_error;
1951: --
1952: end if;
1953: --
1954: hr_utility.set_location(l_proc, 30);
1955: --
1956: end if;
1957: --
1958: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1954: hr_utility.set_location(l_proc, 30);
1955: --
1956: end if;
1957: --
1958: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1959: --
1960: end chk_currency_code;
1961: --
1962: ---------------------------------------------------------------------------
1998: where ssm.salary_survey_line_id = p_salary_survey_line_id;
1999: --
2000: Begin
2001: --
2002: hr_utility.set_location('Entering:'||l_proc, 10);
2003: --
2004: open csr_survey_mapping_exists;
2005: --
2006: fetch csr_survey_mapping_exists into l_exists;
2015: End If;
2016: --
2017: close csr_survey_mapping_exists;
2018: --
2019: hr_utility.set_location('Entering:'||l_proc, 20);
2020: --
2021: End chk_delete;
2022: --
2023: --
2057: l_error exception;
2058: l_argument varchar2(30);
2059: --
2060: Begin
2061: hr_utility.set_location('Entering:'||l_proc, 10);
2062: --
2063: -- Only proceed with validation if a row exists for
2064: -- the current record in the HR Schema
2065: --
2066: if not per_ssl_shd.api_updating
2067: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2068: ,p_object_version_number => p_rec.object_version_number
2069: ) then
2070: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2071: hr_utility.set_message_token('PROCEDURE', l_proc);
2072: hr_utility.set_message_token('STEP', '20');
2073: end if;
2074: --
2067: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2068: ,p_object_version_number => p_rec.object_version_number
2069: ) then
2070: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2071: hr_utility.set_message_token('PROCEDURE', l_proc);
2072: hr_utility.set_message_token('STEP', '20');
2073: end if;
2074: --
2075: hr_utility.set_location(l_proc, 30);
2068: ,p_object_version_number => p_rec.object_version_number
2069: ) then
2070: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2071: hr_utility.set_message_token('PROCEDURE', l_proc);
2072: hr_utility.set_message_token('STEP', '20');
2073: end if;
2074: --
2075: hr_utility.set_location(l_proc, 30);
2076: --
2071: hr_utility.set_message_token('PROCEDURE', l_proc);
2072: hr_utility.set_message_token('STEP', '20');
2073: end if;
2074: --
2075: hr_utility.set_location(l_proc, 30);
2076: --
2077: if (p_rec.salary_survey_id <> per_ssl_shd.g_old_rec.salary_survey_id) then
2078: --
2079: l_argument := 'salary_survey_id';
2081: raise l_error;
2082: --
2083: end if;
2084: --
2085: hr_utility.set_location(l_proc, 40);
2086: --
2087: exception
2088: when l_error then
2089: hr_api.argument_changed_error
2092: );
2093: when others then
2094: raise;
2095: --
2096: hr_utility.set_location(' Leaving:'||l_proc, 50);
2097: --
2098: end chk_non_updateable_args;
2099:
2100: --
2131: --
2132: l_proc varchar2(72) := g_package||'chk_df';
2133: --
2134: Begin
2135: hr_utility.set_location('Entering:'||l_proc, 10);
2136: --
2137: If ((p_rec.salary_survey_line_id is not null) and (
2138: nvl(per_ssl_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2139: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2276: /*End Enhancement 4021737 */
2277: );
2278: End If;
2279: --
2280: hr_utility.set_location(' Leaving:'||l_proc, 20);
2281: End chk_df;
2282: --
2283: -- ----------------------------------------------------------------------------
2284: -- |---------------------------< insert_validate >----------------------------|
2288: --
2289: l_proc varchar2(72) := g_package||'insert_validate';
2290: --
2291: Begin
2292: hr_utility.set_location('Entering:'||l_proc, 5);
2293: --
2294: -- Call all supporting business operations
2295: --
2296: -- Check salary_survey_line_id.
2298: chk_salary_survey_line_id
2299: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2300: ,p_object_version_number => p_rec.object_version_number);
2301: --
2302: hr_utility.set_location(l_proc, 10);
2303: --
2304: -- Check SALARY_SURVEY_ID.
2305: --
2306: chk_salary_survey_id
2307: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2308: ,p_salary_survey_id => p_rec.salary_survey_id
2309: ,p_object_version_number => p_rec.object_version_number);
2310: --
2311: hr_utility.set_location(l_proc, 15);
2312: --
2313: -- Check survey_job_name_code.
2314: --
2315: chk_survey_job_name_code
2318: ,p_salary_survey_id => p_rec.salary_survey_id
2319: ,p_survey_job_name_code => p_rec.survey_job_name_code
2320: ,p_effective_date => p_effective_date);
2321: --
2322: hr_utility.set_location(l_proc, 20);
2323: --
2324: -- Check survey_region_code.
2325: --
2326: chk_survey_region_code
2329: ,p_salary_survey_id => p_rec.salary_survey_id
2330: ,p_survey_region_code => p_rec.survey_region_code
2331: ,p_effective_date => p_effective_date);
2332: --
2333: hr_utility.set_location(l_proc, 25);
2334: --
2335: -- Check survey_seniority_code.
2336: --
2337: chk_survey_seniority_code
2340: ,p_salary_survey_id => p_rec.salary_survey_id
2341: ,p_survey_seniority_code => p_rec.survey_seniority_code
2342: ,p_effective_date => p_effective_date);
2343: --
2344: hr_utility.set_location(l_proc, 30);
2345: --
2346: -- Check company_size_code.
2347: --
2348: chk_company_size_code
2351: ,p_salary_survey_id => p_rec.salary_survey_id
2352: ,p_company_size_code => p_rec.company_size_code
2353: ,p_effective_date => p_effective_date);
2354: --
2355: hr_utility.set_location(l_proc, 35);
2356: --
2357: -- Check industry_code.
2358: --
2359: chk_industry_code
2362: ,p_salary_survey_id => p_rec.salary_survey_id
2363: ,p_industry_code => p_rec.industry_code
2364: ,p_effective_date => p_effective_date);
2365: --
2366: hr_utility.set_location(l_proc, 40);
2367: --
2368: -- Check survey_age_code.
2369: --
2370: chk_survey_age_code
2373: ,p_salary_survey_id => p_rec.salary_survey_id
2374: ,p_survey_age_code => p_rec.survey_age_code
2375: ,p_effective_date => p_effective_date);
2376: --
2377: hr_utility.set_location(l_proc, 43);
2378: --
2379: -- Check stck_display_type_code.
2380: --
2381: chk_stock_display_type_code
2383: ,p_object_version_number => p_rec.object_version_number
2384: ,p_stock_display_type_code => p_rec.stock_display_type
2385: ,p_effective_date => p_effective_date);
2386: --
2387: hr_utility.set_location(l_proc, 20);
2388: --
2389: --
2390: -- Check start_date and end_date
2391: --
2393: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2394: ,p_start_date => p_rec.start_date
2395: ,p_end_date => p_rec.end_date);
2396: --
2397: hr_utility.set_location(l_proc, 45);
2398: --
2399: -- Check all Unique Key columns.
2400: --
2401: chk_unique_key
2410: ,p_survey_age_code => p_rec.survey_age_code
2411: ,p_start_date => p_rec.start_date
2412: ,p_end_date => p_rec.end_date);
2413: --
2414: hr_utility.set_location(l_proc, 50);
2415: --
2416: chk_salary_figures
2417: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2418: ,p_object_version_number => p_rec.object_version_number
2435: ,p_compnstn_third_quartile => p_rec.compnstn_third_quartile
2436: ,p_compnstn_fourth_quartile => p_rec.compnstn_fourth_quartile
2437: );
2438: --
2439: hr_utility.set_location(l_proc, 55);
2440: --
2441: chk_currency_code
2442: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2443: ,p_currency_code => p_rec.currency_code
2442: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2443: ,p_currency_code => p_rec.currency_code
2444: );
2445: --
2446: hr_utility.set_location(l_proc, 60);
2447: -- Call descriptive flexfield validation routines
2448: --
2449: per_ssl_bus.chk_df(p_rec => p_rec);
2450: --
2447: -- Call descriptive flexfield validation routines
2448: --
2449: per_ssl_bus.chk_df(p_rec => p_rec);
2450: --
2451: hr_utility.set_location(' Leaving:'||l_proc, 65);
2452: --
2453: End insert_validate;
2454: --
2455: -- ----------------------------------------------------------------------------
2461: l_proc varchar2(72) := g_package||'update_validate';
2462: --
2463: Begin
2464: --
2465: hr_utility.set_location('Entering:'||l_proc, 5);
2466: --
2467: -- Check for non updateable arguments.
2468: --
2469: chk_non_updateable_args
2470: (p_rec => p_rec
2471: ,p_effective_date => p_effective_date
2472: );
2473: --
2474: hr_utility.set_location(l_proc, 7);
2475: --
2476: --
2477: -- Check salary_survey_line_id.
2478: --
2479: chk_salary_survey_line_id
2480: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2481: ,p_object_version_number => p_rec.object_version_number);
2482: --
2483: hr_utility.set_location(l_proc, 10);
2484: --
2485: -- Check job_name_code.
2486: --
2487: chk_survey_job_name_code
2490: ,p_salary_survey_id => p_rec.salary_survey_id
2491: ,p_survey_job_name_code => p_rec.survey_job_name_code
2492: ,p_effective_date => p_effective_date);
2493: --
2494: hr_utility.set_location(l_proc, 20);
2495: --
2496: --
2497: -- Check survey_region_code.
2498: --
2502: ,p_salary_survey_id => p_rec.salary_survey_id
2503: ,p_survey_region_code => p_rec.survey_region_code
2504: ,p_effective_date => p_effective_date);
2505: --
2506: hr_utility.set_location(l_proc, 25);
2507: --
2508: -- Check survey_seniority_code.
2509: --
2510: chk_survey_seniority_code
2513: ,p_salary_survey_id => p_rec.salary_survey_id
2514: ,p_survey_seniority_code => p_rec.survey_seniority_code
2515: ,p_effective_date => p_effective_date);
2516: --
2517: hr_utility.set_location(l_proc, 30);
2518: --
2519: -- Check company_size_code.
2520: --
2521: chk_company_size_code
2524: ,p_salary_survey_id => p_rec.salary_survey_id
2525: ,p_company_size_code => p_rec.company_size_code
2526: ,p_effective_date => p_effective_date);
2527: --
2528: hr_utility.set_location(l_proc, 35);
2529: --
2530: chk_industry_code
2531: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2532: ,p_object_version_number => p_rec.object_version_number
2533: ,p_salary_survey_id => p_rec.salary_survey_id
2534: ,p_industry_code => p_rec.industry_code
2535: ,p_effective_date => p_effective_date);
2536: --
2537: hr_utility.set_location(l_proc, 40);
2538: --
2539: -- Check survey_age_code.
2540: --
2541: chk_survey_age_code
2544: ,p_salary_survey_id => p_rec.salary_survey_id
2545: ,p_survey_age_code => p_rec.survey_age_code
2546: ,p_effective_date => p_effective_date);
2547: --
2548: hr_utility.set_location(l_proc, 43);
2549: --
2550: -- Check Stock Display Type Code
2551: --
2552: chk_stock_display_type_code
2561: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2562: ,p_start_date => p_rec.start_date
2563: ,p_end_date => p_rec.end_date);
2564: --
2565: hr_utility.set_location(l_proc, 45);
2566: --
2567: -- Check all Unique Key columns.
2568: --
2569: chk_unique_key
2578: ,p_survey_age_code => p_rec.survey_age_code
2579: ,p_start_date => p_rec.start_date
2580: ,p_end_date => p_rec.end_date);
2581: --
2582: hr_utility.set_location(l_proc, 50);
2583: --
2584: chk_salary_figures
2585: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2586: ,p_object_version_number => p_rec.object_version_number
2603: ,p_compnstn_third_quartile => p_rec.compnstn_third_quartile
2604: ,p_compnstn_fourth_quartile => p_rec.compnstn_fourth_quartile
2605: );
2606: --
2607: hr_utility.set_location(l_proc, 55);
2608: --
2609: chk_currency_code
2610: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2611: ,p_currency_code => p_rec.currency_code
2610: (p_salary_survey_line_id => p_rec.salary_survey_line_id
2611: ,p_currency_code => p_rec.currency_code
2612: );
2613: --
2614: hr_utility.set_location(l_proc, 60);
2615: --
2616: -- -- Call descriptive flexfield validation routines
2617: --
2618: per_ssl_bus.chk_df(p_rec => p_rec);
2616: -- -- Call descriptive flexfield validation routines
2617: --
2618: per_ssl_bus.chk_df(p_rec => p_rec);
2619: --
2620: hr_utility.set_location('Leaving:'||l_proc, 65);
2621: --
2622: End update_validate;
2623: --
2624: -- ----------------------------------------------------------------------------
2628: --
2629: l_proc varchar2(72) := g_package||'delete_validate';
2630: --
2631: Begin
2632: hr_utility.set_location('Entering:'||l_proc, 5);
2633: --
2634: -- Call all supporting business operations
2635: --
2636: -- Check that the Survey row is not mapped to a Job or Position.
2636: -- Check that the Survey row is not mapped to a Job or Position.
2637: --
2638: chk_delete(p_salary_survey_line_id => p_rec.salary_survey_line_id);
2639: --
2640: hr_utility.set_location(' Leaving:'||l_proc, 10);
2641: --
2642: End delete_validate;
2643: --
2644: End per_ssl_bus;