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