eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WKS_ERROR_CHK dependencies on PQH_UTILITY

Line 1241: l_warnings_rec pqh_utility.warnings_rec;

1237: l_message_text_out fnd_new_messages.message_text%TYPE;
1238: l_count NUMBER;
1239: l_error_flag varchar2(10) := 'N';
1240: l_message_type varchar2(10) := 'E';
1241: l_warnings_rec pqh_utility.warnings_rec;
1242:
1243:
1244: CURSOR csr_wks_periods IS
1245: SELECT *

Line 1319: pqh_utility.set_message(8302,'PQH_WKS_INVALID_PERIOD_AMT',g_context_organization_id);

1315: ( NVL(l_worksheet_periods_rec.budget_unit3_available,0) < 0 ) THEN
1316:
1317: -- get message text for PQH_WKS_INVALID_PERIOD_AMT
1318: -- message : Budget Period Amount exceeds the allocated amount
1319: pqh_utility.set_message(8302,'PQH_WKS_INVALID_PERIOD_AMT',g_context_organization_id);
1320: l_message_text_out := pqh_utility.get_message;
1321: l_message_type := pqh_utility.get_message_type_cd;
1322:
1323: IF nvl(l_message_type,'E') = 'E' THEN

Line 1320: l_message_text_out := pqh_utility.get_message;

1316:
1317: -- get message text for PQH_WKS_INVALID_PERIOD_AMT
1318: -- message : Budget Period Amount exceeds the allocated amount
1319: pqh_utility.set_message(8302,'PQH_WKS_INVALID_PERIOD_AMT',g_context_organization_id);
1320: l_message_text_out := pqh_utility.get_message;
1321: l_message_type := pqh_utility.get_message_type_cd;
1322:
1323: IF nvl(l_message_type,'E') = 'E' THEN
1324: -- this is a error

Line 1321: l_message_type := pqh_utility.get_message_type_cd;

1317: -- get message text for PQH_WKS_INVALID_PERIOD_AMT
1318: -- message : Budget Period Amount exceeds the allocated amount
1319: pqh_utility.set_message(8302,'PQH_WKS_INVALID_PERIOD_AMT',g_context_organization_id);
1320: l_message_text_out := pqh_utility.get_message;
1321: l_message_type := pqh_utility.get_message_type_cd;
1322:
1323: IF nvl(l_message_type,'E') = 'E' THEN
1324: -- this is a error
1325: IF l_error_flag = 'Y' THEN

Line 1339: -- pqh_utility.init_warnings_table;

1335:
1336: ELSIF nvl(l_message_type,'E') = 'W' THEN
1337: -- this is a warning
1338: l_warnings_rec.message_text := l_message_text_out;
1339: -- pqh_utility.init_warnings_table;
1340: pqh_utility.insert_warning
1341: (
1342: p_warnings_rec => l_warnings_rec
1343: );

Line 1340: pqh_utility.insert_warning

1336: ELSIF nvl(l_message_type,'E') = 'W' THEN
1337: -- this is a warning
1338: l_warnings_rec.message_text := l_message_text_out;
1339: -- pqh_utility.init_warnings_table;
1340: pqh_utility.insert_warning
1341: (
1342: p_warnings_rec => l_warnings_rec
1343: );
1344: -- assign warning message

Line 1440: l_warnings_rec pqh_utility.warnings_rec;

1436: l_unit2_sum NUMBER;
1437: l_unit3_sum NUMBER;
1438: l_worksheet_periods_rec pqh_worksheet_periods%ROWTYPE;
1439: l_message_type varchar2(10) := 'E';
1440: l_warnings_rec pqh_utility.warnings_rec;
1441:
1442:
1443:
1444:

Line 1481: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);

1477: ( NVL(l_unit1_sum,0) <= 0 ) THEN
1478:
1479: -- get message text for PQH_WKS_INVALID_BSET_VAL
1480: -- message : Sum of Budget Sets value for a period must be more then zero
1481: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1482: l_message_text_out := pqh_utility.get_message;
1483: l_message_type := pqh_utility.get_message_type_cd;
1484:
1485: l_message_text := l_message_text_out;

Line 1482: l_message_text_out := pqh_utility.get_message;

1478:
1479: -- get message text for PQH_WKS_INVALID_BSET_VAL
1480: -- message : Sum of Budget Sets value for a period must be more then zero
1481: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1482: l_message_text_out := pqh_utility.get_message;
1483: l_message_type := pqh_utility.get_message_type_cd;
1484:
1485: l_message_text := l_message_text_out;
1486:

Line 1483: l_message_type := pqh_utility.get_message_type_cd;

1479: -- get message text for PQH_WKS_INVALID_BSET_VAL
1480: -- message : Sum of Budget Sets value for a period must be more then zero
1481: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1482: l_message_text_out := pqh_utility.get_message;
1483: l_message_type := pqh_utility.get_message_type_cd;
1484:
1485: l_message_text := l_message_text_out;
1486:
1487: IF nvl(l_message_type,'E') = 'E' THEN

Line 1498: -- pqh_utility.init_warnings_table;

1494: );
1495: ELSIF nvl(l_message_type,'E') = 'W' THEN
1496: -- this is a warning
1497: l_warnings_rec.message_text := l_message_text_out;
1498: -- pqh_utility.init_warnings_table;
1499: pqh_utility.insert_warning
1500: (
1501: p_warnings_rec => l_warnings_rec
1502: );

Line 1499: pqh_utility.insert_warning

1495: ELSIF nvl(l_message_type,'E') = 'W' THEN
1496: -- this is a warning
1497: l_warnings_rec.message_text := l_message_text_out;
1498: -- pqh_utility.init_warnings_table;
1499: pqh_utility.insert_warning
1500: (
1501: p_warnings_rec => l_warnings_rec
1502: );
1503: -- insert warning into process log

Line 1541: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);

1537:
1538:
1539: -- get message text for PQH_WKS_INVALID_BSET_VAL
1540: -- message : Sum of Budget Sets value for a period must be more then zero
1541: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1542: l_message_text_out := pqh_utility.get_message;
1543: l_message_type := pqh_utility.get_message_type_cd;
1544:
1545: l_message_text := l_message_text_out;

Line 1542: l_message_text_out := pqh_utility.get_message;

1538:
1539: -- get message text for PQH_WKS_INVALID_BSET_VAL
1540: -- message : Sum of Budget Sets value for a period must be more then zero
1541: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1542: l_message_text_out := pqh_utility.get_message;
1543: l_message_type := pqh_utility.get_message_type_cd;
1544:
1545: l_message_text := l_message_text_out;
1546:

Line 1543: l_message_type := pqh_utility.get_message_type_cd;

1539: -- get message text for PQH_WKS_INVALID_BSET_VAL
1540: -- message : Sum of Budget Sets value for a period must be more then zero
1541: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1542: l_message_text_out := pqh_utility.get_message;
1543: l_message_type := pqh_utility.get_message_type_cd;
1544:
1545: l_message_text := l_message_text_out;
1546:
1547: IF nvl(l_message_type,'E') = 'E' THEN

Line 1558: -- pqh_utility.init_warnings_table;

1554: );
1555: ELSIF nvl(l_message_type,'E') = 'W' THEN
1556: -- this is a warning
1557: l_warnings_rec.message_text := l_message_text_out;
1558: -- pqh_utility.init_warnings_table;
1559: pqh_utility.insert_warning
1560: (
1561: p_warnings_rec => l_warnings_rec
1562: );

Line 1559: pqh_utility.insert_warning

1555: ELSIF nvl(l_message_type,'E') = 'W' THEN
1556: -- this is a warning
1557: l_warnings_rec.message_text := l_message_text_out;
1558: -- pqh_utility.init_warnings_table;
1559: pqh_utility.insert_warning
1560: (
1561: p_warnings_rec => l_warnings_rec
1562: );
1563: -- insert warning into process log

Line 1603: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);

1599:
1600:
1601: -- get message text for PQH_WKS_INVALID_BSET_VAL
1602: -- message : Sum of Budget Sets value for a period must be more then zero
1603: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1604: l_message_text_out := pqh_utility.get_message;
1605: l_message_type := pqh_utility.get_message_type_cd;
1606:
1607: l_message_text := l_message_text_out;

Line 1604: l_message_text_out := pqh_utility.get_message;

1600:
1601: -- get message text for PQH_WKS_INVALID_BSET_VAL
1602: -- message : Sum of Budget Sets value for a period must be more then zero
1603: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1604: l_message_text_out := pqh_utility.get_message;
1605: l_message_type := pqh_utility.get_message_type_cd;
1606:
1607: l_message_text := l_message_text_out;
1608:

Line 1605: l_message_type := pqh_utility.get_message_type_cd;

1601: -- get message text for PQH_WKS_INVALID_BSET_VAL
1602: -- message : Sum of Budget Sets value for a period must be more then zero
1603: pqh_utility.set_message(8302,'PQH_WKS_INVALID_BSET_VAL',g_context_organization_id);
1604: l_message_text_out := pqh_utility.get_message;
1605: l_message_type := pqh_utility.get_message_type_cd;
1606:
1607: l_message_text := l_message_text_out;
1608:
1609: IF nvl(l_message_type,'E') = 'E' THEN

Line 1620: -- pqh_utility.init_warnings_table;

1616: );
1617: ELSIF nvl(l_message_type,'E') = 'W' THEN
1618: -- this is a warning
1619: l_warnings_rec.message_text := l_message_text_out;
1620: -- pqh_utility.init_warnings_table;
1621: pqh_utility.insert_warning
1622: (
1623: p_warnings_rec => l_warnings_rec
1624: );

Line 1621: pqh_utility.insert_warning

1617: ELSIF nvl(l_message_type,'E') = 'W' THEN
1618: -- this is a warning
1619: l_warnings_rec.message_text := l_message_text_out;
1620: -- pqh_utility.init_warnings_table;
1621: pqh_utility.insert_warning
1622: (
1623: p_warnings_rec => l_warnings_rec
1624: );
1625: -- insert warning into process log

Line 1699: l_warnings_rec pqh_utility.warnings_rec;

1695: l_message_text_out fnd_new_messages.message_text%TYPE;
1696: l_percentage_sum NUMBER;
1697: l_error_flag varchar2(10) := 'N';
1698: l_message_type varchar2(10) := 'E';
1699: l_warnings_rec pqh_utility.warnings_rec;
1700:
1701:
1702:
1703: CURSOR csr_wks_budget_elements IS

Line 1729: pqh_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM',g_context_organization_id);

1725: IF NVL(l_percentage_sum,0) > 100 THEN
1726:
1727: -- get message text for PQH_WKS_INVALID_ELMNT_SUM
1728: -- message : For Budget elements total of percentage under a budget set cannot exceed 100
1729: pqh_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM',g_context_organization_id);
1730:
1731: hr_utility.set_location('Message Set ',6);
1732:
1733: l_message_text_out := pqh_utility.get_message;

Line 1733: l_message_text_out := pqh_utility.get_message;

1729: pqh_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM',g_context_organization_id);
1730:
1731: hr_utility.set_location('Message Set ',6);
1732:
1733: l_message_text_out := pqh_utility.get_message;
1734:
1735: hr_utility.set_location('Get Message Text : '||l_message_text_out,7);
1736:
1737: l_message_type := pqh_utility.get_message_type_cd;

Line 1737: l_message_type := pqh_utility.get_message_type_cd;

1733: l_message_text_out := pqh_utility.get_message;
1734:
1735: hr_utility.set_location('Get Message Text : '||l_message_text_out,7);
1736:
1737: l_message_type := pqh_utility.get_message_type_cd;
1738:
1739: hr_utility.set_location('Get Message Type : '||l_message_type,8);
1740:
1741: -- assign warning message

Line 1750: -- pqh_utility.init_warnings_table;

1746: l_error_flag := 'Y';
1747: ELSIF nvl(l_message_type,'E') = 'W' THEN
1748: -- this is a warning
1749: l_warnings_rec.message_text := l_message_text_out;
1750: -- pqh_utility.init_warnings_table;
1751: pqh_utility.insert_warning
1752: (
1753: p_warnings_rec => l_warnings_rec
1754: );

Line 1751: pqh_utility.insert_warning

1747: ELSIF nvl(l_message_type,'E') = 'W' THEN
1748: -- this is a warning
1749: l_warnings_rec.message_text := l_message_text_out;
1750: -- pqh_utility.init_warnings_table;
1751: pqh_utility.insert_warning
1752: (
1753: p_warnings_rec => l_warnings_rec
1754: );
1755: -- insert warning into process log

Line 1784: pqh_utility.set_message(8302,'PQH_WKS_LESS_ELMNT_SUM',g_context_organization_id);

1780:
1781:
1782: -- get message text for PQH_WKS_LESS_ELMNT_SUM
1783: -- message : Warning : For Budget elements total of percentage under budget set is less then 100
1784: pqh_utility.set_message(8302,'PQH_WKS_LESS_ELMNT_SUM',g_context_organization_id);
1785: l_message_text_out := pqh_utility.get_message;
1786: l_message_type := pqh_utility.get_message_type_cd;
1787:
1788: -- assign warning message

Line 1785: l_message_text_out := pqh_utility.get_message;

1781:
1782: -- get message text for PQH_WKS_LESS_ELMNT_SUM
1783: -- message : Warning : For Budget elements total of percentage under budget set is less then 100
1784: pqh_utility.set_message(8302,'PQH_WKS_LESS_ELMNT_SUM',g_context_organization_id);
1785: l_message_text_out := pqh_utility.get_message;
1786: l_message_type := pqh_utility.get_message_type_cd;
1787:
1788: -- assign warning message
1789: l_message_text := l_message_text_out;

Line 1786: l_message_type := pqh_utility.get_message_type_cd;

1782: -- get message text for PQH_WKS_LESS_ELMNT_SUM
1783: -- message : Warning : For Budget elements total of percentage under budget set is less then 100
1784: pqh_utility.set_message(8302,'PQH_WKS_LESS_ELMNT_SUM',g_context_organization_id);
1785: l_message_text_out := pqh_utility.get_message;
1786: l_message_type := pqh_utility.get_message_type_cd;
1787:
1788: -- assign warning message
1789: l_message_text := l_message_text_out;
1790:

Line 1797: -- pqh_utility.init_warnings_table;

1793: l_error_flag := 'Y';
1794: ELSIF nvl(l_message_type,'E') = 'W' THEN
1795: -- this is a warning
1796: l_warnings_rec.message_text := l_message_text_out;
1797: -- pqh_utility.init_warnings_table;
1798: pqh_utility.insert_warning
1799: (
1800: p_warnings_rec => l_warnings_rec
1801: );

Line 1798: pqh_utility.insert_warning

1794: ELSIF nvl(l_message_type,'E') = 'W' THEN
1795: -- this is a warning
1796: l_warnings_rec.message_text := l_message_text_out;
1797: -- pqh_utility.init_warnings_table;
1798: pqh_utility.insert_warning
1799: (
1800: p_warnings_rec => l_warnings_rec
1801: );
1802: -- insert warning into process log

Line 1920: l_warnings_rec pqh_utility.warnings_rec;

1916: l_message_text_out fnd_new_messages.message_text%TYPE;
1917: l_percentage_sum NUMBER;
1918: l_error_flag varchar2(10) := 'N';
1919: l_message_type varchar2(10) := 'E';
1920: l_warnings_rec pqh_utility.warnings_rec;
1921:
1922:
1923: CURSOR csr_wks_fund_srcs IS
1924: SELECT *

Line 1949: pqh_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM',g_context_organization_id);

1945: IF NVL(l_percentage_sum,0) > 100 THEN
1946:
1947: -- get message text for PQH_WKS_INVALID_SRCS_SUM
1948: -- message : For Budget funding source total of percentage under a budget element cannot exceed 100
1949: pqh_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM',g_context_organization_id);
1950: l_message_text_out := pqh_utility.get_message;
1951: l_message_type := pqh_utility.get_message_type_cd;
1952:
1953: -- assign warning message

Line 1950: l_message_text_out := pqh_utility.get_message;

1946:
1947: -- get message text for PQH_WKS_INVALID_SRCS_SUM
1948: -- message : For Budget funding source total of percentage under a budget element cannot exceed 100
1949: pqh_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM',g_context_organization_id);
1950: l_message_text_out := pqh_utility.get_message;
1951: l_message_type := pqh_utility.get_message_type_cd;
1952:
1953: -- assign warning message
1954: l_message_text := l_message_text_out;

Line 1951: l_message_type := pqh_utility.get_message_type_cd;

1947: -- get message text for PQH_WKS_INVALID_SRCS_SUM
1948: -- message : For Budget funding source total of percentage under a budget element cannot exceed 100
1949: pqh_utility.set_message(8302,'PQH_WKS_INVALID_SRCS_SUM',g_context_organization_id);
1950: l_message_text_out := pqh_utility.get_message;
1951: l_message_type := pqh_utility.get_message_type_cd;
1952:
1953: -- assign warning message
1954: l_message_text := l_message_text_out;
1955:

Line 1962: -- pqh_utility.init_warnings_table;

1958: l_error_flag := 'Y';
1959: ELSIF nvl(l_message_type,'E') = 'W' THEN
1960: -- this is a warning
1961: l_warnings_rec.message_text := l_message_text_out;
1962: -- pqh_utility.init_warnings_table;
1963: pqh_utility.insert_warning
1964: (
1965: p_warnings_rec => l_warnings_rec
1966: );

Line 1963: pqh_utility.insert_warning

1959: ELSIF nvl(l_message_type,'E') = 'W' THEN
1960: -- this is a warning
1961: l_warnings_rec.message_text := l_message_text_out;
1962: -- pqh_utility.init_warnings_table;
1963: pqh_utility.insert_warning
1964: (
1965: p_warnings_rec => l_warnings_rec
1966: );
1967: -- insert warning into process log

Line 1982: pqh_utility.set_message(8302,'PQH_WKS_LESS_SRC_SUM',g_context_organization_id);

1978: ELSIF NVL(l_percentage_sum,0) < 100 THEN
1979:
1980: -- get message text for PQH_WKS_LESS_SRC_SUM
1981: -- message : Warning : For Budget funding source total of percentage under budget element is less then 100
1982: pqh_utility.set_message(8302,'PQH_WKS_LESS_SRC_SUM',g_context_organization_id);
1983: l_message_text_out := pqh_utility.get_message;
1984: l_message_type := pqh_utility.get_message_type_cd;
1985:
1986: -- assign warning message

Line 1983: l_message_text_out := pqh_utility.get_message;

1979:
1980: -- get message text for PQH_WKS_LESS_SRC_SUM
1981: -- message : Warning : For Budget funding source total of percentage under budget element is less then 100
1982: pqh_utility.set_message(8302,'PQH_WKS_LESS_SRC_SUM',g_context_organization_id);
1983: l_message_text_out := pqh_utility.get_message;
1984: l_message_type := pqh_utility.get_message_type_cd;
1985:
1986: -- assign warning message
1987: l_message_text := l_message_text_out;

Line 1984: l_message_type := pqh_utility.get_message_type_cd;

1980: -- get message text for PQH_WKS_LESS_SRC_SUM
1981: -- message : Warning : For Budget funding source total of percentage under budget element is less then 100
1982: pqh_utility.set_message(8302,'PQH_WKS_LESS_SRC_SUM',g_context_organization_id);
1983: l_message_text_out := pqh_utility.get_message;
1984: l_message_type := pqh_utility.get_message_type_cd;
1985:
1986: -- assign warning message
1987: l_message_text := l_message_text_out;
1988:

Line 1995: -- pqh_utility.init_warnings_table;

1991: l_error_flag := 'Y';
1992: ELSIF nvl(l_message_type,'E') = 'W' THEN
1993: -- this is a warning
1994: l_warnings_rec.message_text := l_message_text_out;
1995: -- pqh_utility.init_warnings_table;
1996: pqh_utility.insert_warning
1997: (
1998: p_warnings_rec => l_warnings_rec
1999: );

Line 1996: pqh_utility.insert_warning

1992: ELSIF nvl(l_message_type,'E') = 'W' THEN
1993: -- this is a warning
1994: l_warnings_rec.message_text := l_message_text_out;
1995: -- pqh_utility.init_warnings_table;
1996: pqh_utility.insert_warning
1997: (
1998: p_warnings_rec => l_warnings_rec
1999: );
2000: -- insert warning into process log