1700: l_total_100_percent_flag VARCHAR2(1);
1701: BEGIN
1702:
1703: if p_mandatory = 'Y' then
1704: FND_MESSAGE.set_name('PA', 'PA_MANDATORY_CATG_REQD');
1705: l_return_value := FND_MESSAGE.GET;
1706: return l_return_value;
1707: end if;
1708:
1701: BEGIN
1702:
1703: if p_mandatory = 'Y' then
1704: FND_MESSAGE.set_name('PA', 'PA_MANDATORY_CATG_REQD');
1705: l_return_value := FND_MESSAGE.GET;
1706: return l_return_value;
1707: end if;
1708:
1709: OPEN C1;
1716:
1717: l_return_value := NULL;
1718: if l_total_100_percent_flag = 'Y' then
1719: if l_total_percentage <> 100 then
1720: FND_MESSAGE.set_name('PA', 'PA_CLASS_CATG_NOT_100');
1721: l_return_value := FND_MESSAGE.GET;
1722: return l_return_value;
1723: end if;
1724: end if;
1717: l_return_value := NULL;
1718: if l_total_100_percent_flag = 'Y' then
1719: if l_total_percentage <> 100 then
1720: FND_MESSAGE.set_name('PA', 'PA_CLASS_CATG_NOT_100');
1721: l_return_value := FND_MESSAGE.GET;
1722: return l_return_value;
1723: end if;
1724: end if;
1725:
1814: l_sort_order;
1815: EXIT WHEN l_class_exception%NOTFOUND;
1816:
1817: if l_sort_order = 'A' then
1818: FND_MESSAGE.SET_NAME('PA', 'PA_TOT_PERCENT_MISSING');
1819: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1820: FND_MESSAGE.SET_TOKEN('TOTAL_PERCENTAGE', to_char(l_total_percentage));
1821: FND_MSG_PUB.ADD;
1822: elsif l_sort_order = 'B' then
1815: EXIT WHEN l_class_exception%NOTFOUND;
1816:
1817: if l_sort_order = 'A' then
1818: FND_MESSAGE.SET_NAME('PA', 'PA_TOT_PERCENT_MISSING');
1819: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1820: FND_MESSAGE.SET_TOKEN('TOTAL_PERCENTAGE', to_char(l_total_percentage));
1821: FND_MSG_PUB.ADD;
1822: elsif l_sort_order = 'B' then
1823: FND_MESSAGE.SET_NAME('PA', 'PA_MANDATORY_CLASS_CATEGORY');
1816:
1817: if l_sort_order = 'A' then
1818: FND_MESSAGE.SET_NAME('PA', 'PA_TOT_PERCENT_MISSING');
1819: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1820: FND_MESSAGE.SET_TOKEN('TOTAL_PERCENTAGE', to_char(l_total_percentage));
1821: FND_MSG_PUB.ADD;
1822: elsif l_sort_order = 'B' then
1823: FND_MESSAGE.SET_NAME('PA', 'PA_MANDATORY_CLASS_CATEGORY');
1824: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1819: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1820: FND_MESSAGE.SET_TOKEN('TOTAL_PERCENTAGE', to_char(l_total_percentage));
1821: FND_MSG_PUB.ADD;
1822: elsif l_sort_order = 'B' then
1823: FND_MESSAGE.SET_NAME('PA', 'PA_MANDATORY_CLASS_CATEGORY');
1824: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1825: FND_MSG_PUB.ADD;
1826: end if;
1827:
1820: FND_MESSAGE.SET_TOKEN('TOTAL_PERCENTAGE', to_char(l_total_percentage));
1821: FND_MSG_PUB.ADD;
1822: elsif l_sort_order = 'B' then
1823: FND_MESSAGE.SET_NAME('PA', 'PA_MANDATORY_CLASS_CATEGORY');
1824: FND_MESSAGE.SET_TOKEN('CLASS_CATEGORY', l_class_category);
1825: FND_MSG_PUB.ADD;
1826: end if;
1827:
1828: END LOOP;