DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on FND_MESSAGE

Line 1343: FND_MESSAGE.Set_Name('CN', 'NOT_WITHIN_OPEN_PERIODS');

1339: AND org_id = p_newtx_rec.org_id;
1340: --
1341: IF (l_period_count = 0) THEN
1342: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1343: FND_MESSAGE.Set_Name('CN', 'NOT_WITHIN_OPEN_PERIODS');
1344: FND_MSG_PUB.Add;
1345: END IF;
1346: x_loading_status := 'NOT_WITHIN_OPEN_PERIODS';
1347: RAISE FND_API.G_EXC_ERROR ;

Line 1410: FND_MESSAGE.SET_NAME('CN','CN_ADJ_NO_CONVERSION');

1406: x_to_amount => l_newtx_rec.transaction_amount,
1407: x_return_status => l_return_status,
1408: p_conversion_type => CN_SYSTEM_PARAMETERS.VALUE('CN_CONVERSION_TYPE', p_newtx_rec.org_id));
1409: IF (l_return_status = 'NO DATA') THEN
1410: FND_MESSAGE.SET_NAME('CN','CN_ADJ_NO_CONVERSION');
1411: FND_MSG_PUB.Add;
1412: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: ELSIF (l_return_status = 'ERROR') THEN

Line 1415: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');

1411: FND_MSG_PUB.Add;
1412: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: ELSIF (l_return_status = 'ERROR') THEN
1415: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');
1416: FND_MSG_PUB.Add;
1417: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END IF;

Line 1440: FND_MESSAGE.SET_NAME('CN','CN_ADJ_NO_CONVERSION');

1436: x_to_amount => l_newtx_rec.transaction_amount_orig,
1437: x_return_status => l_return_status,
1438: p_conversion_type => CN_SYSTEM_PARAMETERS.VALUE('CN_CONVERSION_TYPE', p_newtx_rec.org_id));
1439: IF (l_return_status = 'NO DATA') THEN
1440: FND_MESSAGE.SET_NAME('CN','CN_ADJ_NO_CONVERSION');
1441: FND_MSG_PUB.Add;
1442: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = 'ERROR') THEN

Line 1445: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');

1441: FND_MSG_PUB.Add;
1442: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = 'ERROR') THEN
1445: FND_MESSAGE.SET_NAME('CN','CN_ADJ_CONV_ERROR');
1446: FND_MSG_PUB.Add;
1447: x_loading_status := 'CN_ADJ_NO_CONVERSION';
1448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1449: END IF;

Line 1851: FND_MESSAGE.Set_Name('CN', 'CN_NO_SPLIT_RESOURCE');

1847: END IF;
1848: END LOOP;
1849: IF (l_id_counter = 0) THEN
1850: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1851: FND_MESSAGE.Set_Name('CN', 'CN_NO_SPLIT_RESOURCE');
1852: FND_MSG_PUB.Add;
1853: END IF;
1854: x_loading_status := 'CN_NO_SPLIT_RESOURCE';
1855: RAISE FND_API.G_EXC_ERROR;

Line 1878: -- FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_AMOUNT');

1874:
1875: -- bug 2118574
1876: -- IF (l_split_amount <> p_transaction_amount) THEN
1877: -- IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1878: -- FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_AMOUNT');
1879: -- FND_MSG_PUB.Add;
1880: -- END IF;
1881: -- x_loading_status := 'CN_ADJ_SPLIT_AMOUNT';
1882: -- RAISE FND_API.G_EXC_ERROR;

Line 1888: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');

1884:
1885:
1886: IF (l_split_percent <> l_adj_tbl(1).split_pct) THEN
1887: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1888: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');
1889: FND_MSG_PUB.Add;
1890: END IF;
1891: x_loading_status := 'CN_ADJ_SPLIT_PERCENT';
1892: RAISE FND_API.G_EXC_ERROR;

Line 1932: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');

1928: x_loading_status => x_loading_status);
1929: --
1930: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1931: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1932: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
1933: FND_MSG_PUB.Add;
1934: END IF;
1935: x_loading_status := 'CN_UPDATE_INV_ERROR';
1936: RAISE FND_API.G_EXC_ERROR;

Line 2048: FND_MESSAGE.Set_Name('CN', 'CN_SPLIT_TRX_ERROR');

2044: --
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2048: FND_MESSAGE.Set_Name('CN', 'CN_SPLIT_TRX_ERROR');
2049: FND_MSG_PUB.Add;
2050: END IF;
2051: x_loading_status := 'CN_SPLIT_TRX_ERROR';
2052: RAISE FND_API.G_EXC_ERROR;

Line 2075: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');

2071: x_loading_status => x_loading_status);
2072: --
2073: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2074: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2075: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
2076: FND_MSG_PUB.Add;
2077: END IF;
2078: x_loading_status := 'CN_UPDATE_INV_ERROR';
2079: RAISE FND_API.G_EXC_ERROR;

Line 2100: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_CM_ERROR');

2096: END IF;
2097: --
2098: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2099: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2100: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_CM_ERROR');
2101: FND_MSG_PUB.Add;
2102: END IF;
2103: x_loading_status := 'CN_UPDATE_CM_ERROR';
2104: RAISE FND_API.G_EXC_ERROR;

Line 2146: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');

2142: END IF;
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2146: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');
2147: FND_MSG_PUB.Add;
2148: END IF;
2149: x_loading_status := 'CN_DEAL_REV_ERROR';
2150: RAISE FND_API.G_EXC_ERROR;

Line 2178: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');

2174: END IF;
2175: EXCEPTION
2176: WHEN OTHERS THEN
2177: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2178: FND_MESSAGE.Set_Name('CN', 'CN_DEAL_REV_ERROR');
2179: FND_MSG_PUB.Add;
2180: END IF;
2181: x_loading_status := 'CN_DEAL_REV_ERROR';
2182: RAISE FND_API.G_EXC_ERROR;

Line 2194: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');

2190: END IF;
2191: END LOOP;
2192: IF ((l_split_percent <> 100) AND (l_deal_type = 'REVENUE')) THEN
2193: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2194: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_SPLIT_PERCENT');
2195: FND_MSG_PUB.Add;
2196: END IF;
2197: x_loading_status := 'CN_ADJ_SPLIT_PERCENT';
2198: RAISE FND_API.G_EXC_ERROR;

Line 2336: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');

2332:
2333: --
2334: IF (l_data_exist = 'N') THEN
2335: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2336: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');
2337: FND_MSG_PUB.Add;
2338: END IF;
2339: x_loading_status := 'CN_NO_REC_DEAL';
2340: RAISE FND_API.G_EXC_ERROR;

Line 2477: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');

2473: END LOOP;
2474: END LOOP;
2475: ELSE
2476: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2477: FND_MESSAGE.Set_Name('CN', 'CN_NO_REC_DEAL');
2478: FND_MSG_PUB.Add;
2479: END IF;
2480: x_loading_status := 'CN_NO_REC_DEAL';
2481: RAISE FND_API.G_EXC_ERROR;

Line 2508: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');

2504: x_loading_status => x_loading_status);
2505: --
2506: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2507: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
2508: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
2509: FND_MSG_PUB.Add;
2510: END IF;
2511: x_loading_status := 'CN_UPDATE_INV_ERROR';
2512: RAISE FND_API.G_EXC_ERROR;

Line 3089: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');

3085: x_loading_status => x_loading_status);
3086: --
3087: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3088: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3089: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3090: FND_MSG_PUB.Add;
3091: END IF;
3092: x_loading_status := 'CN_UPDATE_INV_ERROR';
3093: RAISE FND_API.G_EXC_ERROR;

Line 3176: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');

3172: x_loading_status => x_loading_status);
3173: --
3174: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3175: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3176: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3177: FND_MSG_PUB.Add;
3178: END IF;
3179: x_loading_status := 'CN_UPDATE_INV_ERROR';
3180: RAISE FND_API.G_EXC_ERROR;