1815:
1816: BEGIN
1817:
1818: IF p_error_code = 'XTR_PORTFOLIO' THEN
1819: FND_MESSAGE.Set_Name('XTR','XTR_2208');
1820: FND_MSG_PUB.ADD;
1821:
1822: ELSIF p_error_code = 'XTR_INV_PRICING_MODEL' THEN
1823: FND_MESSAGE.Set_Name('XTR','XTR_INV_PRICING_MODEL');
1819: FND_MESSAGE.Set_Name('XTR','XTR_2208');
1820: FND_MSG_PUB.ADD;
1821:
1822: ELSIF p_error_code = 'XTR_INV_PRICING_MODEL' THEN
1823: FND_MESSAGE.Set_Name('XTR','XTR_INV_PRICING_MODEL');
1824: FND_MSG_PUB.ADD;
1825:
1826: ELSIF p_error_code = 'CE_NO_SCHED_BANK_ACCT' THEN
1827: FND_MESSAGE.Set_Name('CE','CE_NO_SCHED_BANK_ACCT');
1823: FND_MESSAGE.Set_Name('XTR','XTR_INV_PRICING_MODEL');
1824: FND_MSG_PUB.ADD;
1825:
1826: ELSIF p_error_code = 'CE_NO_SCHED_BANK_ACCT' THEN
1827: FND_MESSAGE.Set_Name('CE','CE_NO_SCHED_BANK_ACCT');
1828: FND_MSG_PUB.ADD;
1829:
1830:
1831: ELSIF p_error_code = 'XTR_REVAL_ACCRL_BANK' THEN
1829:
1830:
1831: ELSIF p_error_code = 'XTR_REVAL_ACCRL_BANK' THEN
1832: /* warning has to be raised will look into this later */
1833: FND_MESSAGE.Set_Name ('XTR', 'XTR_REVAL_ACCRL_BANK');
1834: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1835: FND_MSG_PUB.ADD;
1836:
1837: ELSIF p_error_code = 'XTR_BANK_ACCRLS_EXIST' THEN
1830:
1831: ELSIF p_error_code = 'XTR_REVAL_ACCRL_BANK' THEN
1832: /* warning has to be raised will look into this later */
1833: FND_MESSAGE.Set_Name ('XTR', 'XTR_REVAL_ACCRL_BANK');
1834: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1835: FND_MSG_PUB.ADD;
1836:
1837: ELSIF p_error_code = 'XTR_BANK_ACCRLS_EXIST' THEN
1838: FND_MESSAGE.Set_Name ('XTR', 'XTR_BANK_ACCRLS_EXIST');
1834: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1835: FND_MSG_PUB.ADD;
1836:
1837: ELSIF p_error_code = 'XTR_BANK_ACCRLS_EXIST' THEN
1838: FND_MESSAGE.Set_Name ('XTR', 'XTR_BANK_ACCRLS_EXIST');
1839: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1840: FND_MSG_PUB.ADD;
1841:
1842: ELSIF p_error_code = 'XTR_BANK_REVAL_DONE' THEN
1835: FND_MSG_PUB.ADD;
1836:
1837: ELSIF p_error_code = 'XTR_BANK_ACCRLS_EXIST' THEN
1838: FND_MESSAGE.Set_Name ('XTR', 'XTR_BANK_ACCRLS_EXIST');
1839: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1840: FND_MSG_PUB.ADD;
1841:
1842: ELSIF p_error_code = 'XTR_BANK_REVAL_DONE' THEN
1843: FND_MESSAGE.Set_Name ('XTR', 'XTR_BANK_REVAL_DONE');
1839: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1840: FND_MSG_PUB.ADD;
1841:
1842: ELSIF p_error_code = 'XTR_BANK_REVAL_DONE' THEN
1843: FND_MESSAGE.Set_Name ('XTR', 'XTR_BANK_REVAL_DONE');
1844: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1845: FND_MSG_PUB.ADD;
1846:
1847: ELSIF p_error_code = 'XTR_ACCT_DELETE' THEN
1840: FND_MSG_PUB.ADD;
1841:
1842: ELSIF p_error_code = 'XTR_BANK_REVAL_DONE' THEN
1843: FND_MESSAGE.Set_Name ('XTR', 'XTR_BANK_REVAL_DONE');
1844: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1845: FND_MSG_PUB.ADD;
1846:
1847: ELSIF p_error_code = 'XTR_ACCT_DELETE' THEN
1848: FND_MESSAGE.Set_Name ('XTR', 'XTR_ACCT_DELETE');
1844: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1845: FND_MSG_PUB.ADD;
1846:
1847: ELSIF p_error_code = 'XTR_ACCT_DELETE' THEN
1848: FND_MESSAGE.Set_Name ('XTR', 'XTR_ACCT_DELETE');
1849: FND_MSG_PUB.ADD;
1850:
1851: ELSIF p_error_code = 'XTR_REVAL_ACCRL_DATE' THEN
1852: /* warning has to be raised will look into this later */
1849: FND_MSG_PUB.ADD;
1850:
1851: ELSIF p_error_code = 'XTR_REVAL_ACCRL_DATE' THEN
1852: /* warning has to be raised will look into this later */
1853: FND_MESSAGE.Set_Name ('XTR', 'XTR_REVAL_ACCRL_DATE');
1854: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1855: FND_MSG_PUB.ADD;
1856:
1857: ELSIF p_error_code = 'XTR_CA_REVAL_DONE' THEN
1850:
1851: ELSIF p_error_code = 'XTR_REVAL_ACCRL_DATE' THEN
1852: /* warning has to be raised will look into this later */
1853: FND_MESSAGE.Set_Name ('XTR', 'XTR_REVAL_ACCRL_DATE');
1854: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1855: FND_MSG_PUB.ADD;
1856:
1857: ELSIF p_error_code = 'XTR_CA_REVAL_DONE' THEN
1858: FND_MESSAGE.Set_Name ('XTR', 'XTR_CA_REVAL_DONE');
1854: FND_MESSAGE.Set_Token ('DATE',p_balance_date);
1855: FND_MSG_PUB.ADD;
1856:
1857: ELSIF p_error_code = 'XTR_CA_REVAL_DONE' THEN
1858: FND_MESSAGE.Set_Name ('XTR', 'XTR_CA_REVAL_DONE');
1859: FND_MSG_PUB.ADD;
1860:
1861: ELSIF p_error_code = 'XTR_104' THEN
1862: FND_MESSAGE.Set_Name ( 'XTR','XTR_104');
1858: FND_MESSAGE.Set_Name ('XTR', 'XTR_CA_REVAL_DONE');
1859: FND_MSG_PUB.ADD;
1860:
1861: ELSIF p_error_code = 'XTR_104' THEN
1862: FND_MESSAGE.Set_Name ( 'XTR','XTR_104');
1863: FND_MSG_PUB.ADD;
1864:
1865: ELSIF p_error_code = 'XTR_1237' THEN
1866: FND_MESSAGE.Set_Name ( 'XTR','XTR_1237');
1862: FND_MESSAGE.Set_Name ( 'XTR','XTR_104');
1863: FND_MSG_PUB.ADD;
1864:
1865: ELSIF p_error_code = 'XTR_1237' THEN
1866: FND_MESSAGE.Set_Name ( 'XTR','XTR_1237');
1867: FND_MSG_PUB.ADD;
1868:
1869: ELSIF p_error_code = 'XTR_UNEXP_ERROR' THEN
1870: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');
1866: FND_MESSAGE.Set_Name ( 'XTR','XTR_1237');
1867: FND_MSG_PUB.ADD;
1868:
1869: ELSIF p_error_code = 'XTR_UNEXP_ERROR' THEN
1870: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');
1871: FND_MESSAGE.Set_Token('SQLCODE', p_field_name);
1872: FND_MSG_PUB.ADD; -- Adds the error messages to the list.
1873:
1874: ELSIF p_error_code = 'CHK_LOCK' THEN
1867: FND_MSG_PUB.ADD;
1868:
1869: ELSIF p_error_code = 'XTR_UNEXP_ERROR' THEN
1870: FND_MESSAGE.Set_Name('XTR','XTR_UNEXP_ERROR');
1871: FND_MESSAGE.Set_Token('SQLCODE', p_field_name);
1872: FND_MSG_PUB.ADD; -- Adds the error messages to the list.
1873:
1874: ELSIF p_error_code = 'CHK_LOCK' THEN
1875: FND_MESSAGE.Set_Name('XTR','XTR_1999');
1871: FND_MESSAGE.Set_Token('SQLCODE', p_field_name);
1872: FND_MSG_PUB.ADD; -- Adds the error messages to the list.
1873:
1874: ELSIF p_error_code = 'CHK_LOCK' THEN
1875: FND_MESSAGE.Set_Name('XTR','XTR_1999');
1876: FND_MSG_PUB.ADD;
1877:
1878:
1879: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
1876: FND_MSG_PUB.ADD;
1877:
1878:
1879: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
1880: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAM');
1881: FND_MESSAGE.Set_Token('FIELD', p_field_name);
1882: FND_MSG_PUB.ADD;
1883:
1884: ELSIF p_error_code = 'XTR_TYPES_CHANGED' THEN
1877:
1878:
1879: ELSIF p_error_code = 'XTR_INV_PARAM' THEN
1880: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAM');
1881: FND_MESSAGE.Set_Token('FIELD', p_field_name);
1882: FND_MSG_PUB.ADD;
1883:
1884: ELSIF p_error_code = 'XTR_TYPES_CHANGED' THEN
1885: FND_MESSAGE.Set_Name('XTR','XTR_TYPES_CHANGED');
1881: FND_MESSAGE.Set_Token('FIELD', p_field_name);
1882: FND_MSG_PUB.ADD;
1883:
1884: ELSIF p_error_code = 'XTR_TYPES_CHANGED' THEN
1885: FND_MESSAGE.Set_Name('XTR','XTR_TYPES_CHANGED');
1886: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);
1887: FND_MSG_PUB.ADD;
1888:
1889: ELSIF p_error_code = 'XTR_CHANGED_DAYCOUNT_ROUND' THEN
1882: FND_MSG_PUB.ADD;
1883:
1884: ELSIF p_error_code = 'XTR_TYPES_CHANGED' THEN
1885: FND_MESSAGE.Set_Name('XTR','XTR_TYPES_CHANGED');
1886: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);
1887: FND_MSG_PUB.ADD;
1888:
1889: ELSIF p_error_code = 'XTR_CHANGED_DAYCOUNT_ROUND' THEN
1890: FND_MESSAGE.Set_Name('XTR', 'XTR_CHANGED_DAYCOUNT_ROUND');
1886: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);
1887: FND_MSG_PUB.ADD;
1888:
1889: ELSIF p_error_code = 'XTR_CHANGED_DAYCOUNT_ROUND' THEN
1890: FND_MESSAGE.Set_Name('XTR', 'XTR_CHANGED_DAYCOUNT_ROUND');
1891: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);
1892: FND_MSG_PUB.ADD;
1893:
1894:
1887: FND_MSG_PUB.ADD;
1888:
1889: ELSIF p_error_code = 'XTR_CHANGED_DAYCOUNT_ROUND' THEN
1890: FND_MESSAGE.Set_Name('XTR', 'XTR_CHANGED_DAYCOUNT_ROUND');
1891: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);
1892: FND_MSG_PUB.ADD;
1893:
1894:
1895: