APPS.PSA_UTILS dependencies on APP_EXCEPTION

Line 1703: app_exception.raise_exception;

1699: l_end_date DATE;
1700: BEGIN
1701: IF p_user_name IS NULL THEN
1702: undo_error ('User Name not entered');
1703: app_exception.raise_exception;
1704: END IF;
1705:
1706: SELECT user_id,
1707: start_date,

Line 1719: app_exception.raise_exception;

1715: NULL;
1716: ELSE
1717: undo_error ('This is an expired user: '||p_user_name);
1718: error ('Please use a valid user.');
1719: app_exception.raise_exception;
1720: END IF;
1721: EXCEPTION
1722: WHEN NO_DATA_FOUND THEN
1723: undo_error ('No such user found: '||p_user_name);

Line 1740: app_exception.raise_exception;

1736: l_end_date DATE;
1737: BEGIN
1738: IF p_user_id IS NULL THEN
1739: undo_error ('User Id not entered');
1740: app_exception.raise_exception;
1741: END IF;
1742:
1743: SELECT start_date,
1744: end_date

Line 1754: app_exception.raise_exception;

1750: NULL;
1751: ELSE
1752: undo_error ('This is an expired user id: '||p_user_id);
1753: error ('Please use a valid user.');
1754: app_exception.raise_exception;
1755: END IF;
1756: EXCEPTION
1757: WHEN NO_DATA_FOUND THEN
1758: undo_error ('No such user id found: '||p_user_id);

Line 1780: app_exception.raise_exception;

1776:
1777: BEGIN
1778: IF p_resp_id IS NULL THEN
1779: undo_error ('Resp Id not entered');
1780: app_exception.raise_exception;
1781: END IF;
1782:
1783: BEGIN
1784: SELECT application_name

Line 1802: app_exception.raise_exception;

1798: IF (SYSDATE BETWEEN l_start_date AND NVL(l_end_date, SYSDATE)) THEN
1799: NULL;
1800: ELSE
1801: undo_error ('This is an expired Responsibility '||p_resp_id);
1802: app_exception.raise_exception;
1803: END IF;
1804: EXCEPTION
1805: WHEN NO_DATA_FOUND THEN
1806: undo_error ('No such Repsonsibility exists: '||p_resp_id);

Line 1827: app_exception.raise_exception;

1823:
1824: IF (SYSDATE BETWEEN l_start_date AND NVL(l_end_date, SYSDATE)) THEN
1825: IF (l_resp_appl_id <> p_appl_id) THEN
1826: undo_error ('The Repsonsibility is not '||l_appl_name);
1827: app_exception.raise_exception;
1828: END IF;
1829: ELSE
1830: undo_error ('User does not have access to the Repsonsibility');
1831: app_exception.raise_exception;

Line 1831: app_exception.raise_exception;

1827: app_exception.raise_exception;
1828: END IF;
1829: ELSE
1830: undo_error ('User does not have access to the Repsonsibility');
1831: app_exception.raise_exception;
1832: END IF;
1833:
1834: EXCEPTION
1835: WHEN NO_DATA_FOUND THEN

Line 1863: app_exception.raise_exception;

1859: l_ledger_name gl_ledgers.name%TYPE;
1860: BEGIN
1861: IF p_invoice_id IS NULL THEN
1862: undo_error ('Invoice Id not entered');
1863: app_exception.raise_exception;
1864: END IF;
1865:
1866: fnd_global.apps_initialize(p_user_id, p_resp_id, 200);
1867: mo_global.init('SQLAP');

Line 1901: app_exception.raise_exception;

1897: l_ledger_name gl_ledgers.name%TYPE;
1898: BEGIN
1899: IF p_po_header_id IS NULL THEN
1900: undo_error ('PO Header Id not entered');
1901: app_exception.raise_exception;
1902: END IF;
1903:
1904: fnd_global.apps_initialize(p_user_id, p_resp_id, 200);
1905: mo_global.init('SQLAP');

Line 1936: app_exception.raise_exception;

1932: l_gl_period_name gl_period_statuses.period_name%TYPE;
1933: BEGIN
1934: IF p_gl_date IS NULL THEN
1935: undo_error ('GL Date is not entered');
1936: app_exception.raise_exception;
1937: END IF;
1938:
1939: SELECT p.closing_status,
1940: p.period_name

Line 1952: app_exception.raise_exception;

1948:
1949: IF (l_gl_period_status <> 'O') THEN
1950: undo_error('Period '||l_gl_period_name||' is not open');
1951: error('Please Open the period or provide another GL Date');
1952: app_exception.raise_exception;
1953: END IF;
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND THEN
1956: undo_error ('Could not find GL Date '||p_gl_date||' in any of the periods');

Line 1971: app_exception.raise_exception;

1967: IS
1968: BEGIN
1969: IF p_tar_number IS NULL THEN
1970: undo_error ('TAR Number is not Entered');
1971: app_exception.raise_exception;
1972: END IF;
1973: END;
1974:
1975:

Line 1984: app_exception.raise_exception;

1980: IS
1981: BEGIN
1982: IF p_mode IS NULL or p_mode not in ( 'A', 'B') THEN
1983: undo_error ('Invalid Undo mode , Please enter A or B');
1984: app_exception.raise_exception;
1985: END IF;
1986: END;
1987:
1988:

Line 1997: app_exception.raise_exception;

1993: IS
1994: BEGIN
1995: IF p_bug_number IS NULL THEN
1996: undo_error ('Bug Number is not Entered');
1997: app_exception.raise_exception;
1998: END IF;
1999: END;
2000:
2001: BEGIN