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.XTR_REPLICATE_BANK_BALANCES dependencies on FND_MSG_PUB

Line 42: FND_MSG_PUB.Initialize;

38:
39:
40: BEGIN
41: l_balance_date_updated := FALSE;
42: FND_MSG_PUB.Initialize;
43: IF(p_action_flag in ('U','D')) THEN
44:
45: OPEN C_BALANCE_DETAILS;
46: FETCH C_BALANCE_DETAILS INTO l_balance_rec.company_code,l_balance_rec.account_number

Line 187: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

183:
184:
185: END IF;
186:
187: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
188: ( p_count => x_msg_count ,
189: p_data => x_msg_data
190: );
191:

Line 199: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

195: WHEN others THEN
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
198:
199: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
200: ( p_count => x_msg_count ,
201: p_data => x_msg_data
202: );
203:

Line 305: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

301: WHEN others THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
304:
305: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
306: ( p_count => x_msg_count ,
307: p_data => x_msg_data
308: );
309:

Line 1044: FND_MSG_PUB.Initialize;

1040: BEGIN
1041:
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043: l_balance_date_updated := FALSE;
1044: FND_MSG_PUB.Initialize;
1045: IF(p_action_flag in ('U','D')) THEN
1046:
1047: OPEN C_BALANCE_DETAILS;
1048: FETCH C_BALANCE_DETAILS INTO l_balance_rec.company_code,l_balance_rec.account_number

Line 1115: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1111:
1112:
1113: END IF;
1114:
1115: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1116: ( p_count => x_msg_count ,
1117: p_data => x_msg_data
1118: );
1119:

Line 1127: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

1123: WHEN others THEN
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
1126:
1127: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
1128: ( p_count => x_msg_count ,
1129: p_data => x_msg_data
1130: );
1131:

Line 1820: FND_MSG_PUB.ADD;

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');
1824: FND_MSG_PUB.ADD;

Line 1824: FND_MSG_PUB.ADD;

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');
1828: FND_MSG_PUB.ADD;

Line 1828: FND_MSG_PUB.ADD;

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
1832: /* warning has to be raised will look into this later */

Line 1835: FND_MSG_PUB.ADD;

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');
1839: FND_MESSAGE.Set_Token ('DATE',p_balance_date);

Line 1840: 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');
1844: FND_MESSAGE.Set_Token ('DATE',p_balance_date);

Line 1845: 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');
1849: FND_MSG_PUB.ADD;

Line 1849: FND_MSG_PUB.ADD;

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 */
1853: FND_MESSAGE.Set_Name ('XTR', 'XTR_REVAL_ACCRL_DATE');

Line 1855: FND_MSG_PUB.ADD;

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');
1859: FND_MSG_PUB.ADD;

Line 1859: FND_MSG_PUB.ADD;

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');
1863: FND_MSG_PUB.ADD;

Line 1863: FND_MSG_PUB.ADD;

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');
1867: FND_MSG_PUB.ADD;

Line 1867: FND_MSG_PUB.ADD;

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');
1871: FND_MESSAGE.Set_Token('SQLCODE', p_field_name);

Line 1872: FND_MSG_PUB.ADD; -- Adds the error messages to the list.

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');
1876: FND_MSG_PUB.ADD;

Line 1876: FND_MSG_PUB.ADD;

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
1880: FND_MESSAGE.Set_Name('XTR','XTR_INV_PARAM');

Line 1882: FND_MSG_PUB.ADD;

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');
1886: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);

Line 1887: 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');
1891: -- FND_MESSAGE.Set_Token('FIELD', p_field_name);

Line 1892: 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:
1896:

Line 2168: FND_MSG_PUB.Initialize;

2164: l_currency xtr_bank_accounts.currency%TYPE;
2165: l_return_error VARCHAR2(30);
2166:
2167: BEGIN
2168: FND_MSG_PUB.Initialize;
2169:
2170: OPEN c_bank_acct_details;
2171: FETCH c_bank_acct_details INTO l_company_code,l_account_number,l_currency;
2172: IF c_bank_acct_details%FOUND THEN

Line 2208: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: LOG_ERR_MSG('XTR_INV_PARAM','ACTION_FLAG');
2206: END IF;
2207:
2208: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
2209: ( p_count => x_msg_count ,
2210: p_data => x_msg_data
2211: );
2212:

Line 2218: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error

2214:
2215: WHEN others THEN
2216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2217: LOG_ERR_MSG('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2218: FND_MSG_PUB.Count_And_Get -- Returns the error message if there is only 1 error
2219: ( p_count => x_msg_count ,
2220: p_data => x_msg_data
2221: );
2222:

Line 2277: FND_MSG_PUB.Count_And_Get

2273: WHEN others THEN
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: LOG_ERR_MSG ('XTR_UNEXP_ERROR',SQLERRM(SQLCODE));
2276:
2277: FND_MSG_PUB.Count_And_Get
2278: ( p_count => x_msg_count ,
2279: p_data => x_msg_data
2280: );
2281: