DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3064: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_ADJUST_OBSOLETE');

3060: a.terr_id IS NOT NULL);
3061:
3062: IF l_comm_line_count > 0 THEN
3063: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3064: FND_MESSAGE.Set_Name('CN', 'CN_ADJ_ADJUST_OBSOLETE');
3065: FND_MSG_PUB.Add;
3066: END IF;
3067: x_loading_status := 'CN_ADJUST_TX_ERROR';
3068: RAISE FND_API.G_EXC_ERROR;

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

3111: x_loading_status => x_loading_status);
3112: --
3113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3114: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3115: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3116: FND_MSG_PUB.Add;
3117: END IF;
3118: x_loading_status := 'CN_UPDATE_INV_ERROR';
3119: RAISE FND_API.G_EXC_ERROR;

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

3198: x_loading_status => x_loading_status);
3199: --
3200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3201: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
3202: FND_MESSAGE.Set_Name('CN', 'CN_UPDATE_INV_ERROR');
3203: FND_MSG_PUB.Add;
3204: END IF;
3205: x_loading_status := 'CN_UPDATE_INV_ERROR';
3206: RAISE FND_API.G_EXC_ERROR;