DBA Data[Home] [Help]

APPS.IEM_ROUTE_PVT dependencies on FND_MESSAGE

Line 198: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');

194:
195: WHEN IEM_ROUTE_NOT_DELETED THEN
196: ROLLBACK TO delete_item_batch;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
199:
200: FND_MSG_PUB.ADD;
201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
202:

Line 376: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');

372:
373: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
374:
375: ROLLBACK TO create_item_wrap;
376: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
380:

Line 602: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_DUP_NAME');

598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
599:
600: WHEN IEM_ADMIN_ROUTE_DUP_NAME THEN
601: ROLLBACK TO create_item_routes_PVT;
602: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_DUP_NAME');
603: FND_MSG_PUB.Add;
604: x_return_status := FND_API.G_RET_STS_ERROR ;
605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
606:

Line 609: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_NO_PROCEDURE_NAME');

605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
606:
607: WHEN IEM_ADM_NO_PROCEDURE_NAME THEN
608: ROLLBACK TO create_item_routes_PVT;
609: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_NO_PROCEDURE_NAME');
610: FND_MSG_PUB.Add;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
613:

Line 1230: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');

1226:
1227: EXCEPTION
1228: WHEN l_IEM_FAIL_TO_CALL THEN
1229: ROLLBACK TO update_item_wrap;
1230: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
1231:
1232: -- FND_MSG_PUB.Add;
1233: x_return_status := FND_API.G_RET_STS_ERROR ;
1234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1238: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');

1234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1235:
1236: WHEN IEM_NO_ROUTE_UPDATE THEN
1237: ROLLBACK TO update_item_wrap;
1238: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
1239:
1240: FND_MSG_PUB.Add;
1241: x_return_status := FND_API.G_RET_STS_ERROR ;
1242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1245: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');

1241: x_return_status := FND_API.G_RET_STS_ERROR ;
1242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1243: WHEN IEM_NO_RULE_UPDATE THEN
1244: ROLLBACK TO update_item_wrap;
1245: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1246: FND_MSG_PUB.Add;
1247: x_return_status := FND_API.G_RET_STS_ERROR ;
1248: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1249:

Line 1253: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');

1249:
1250: WHEN IEM_RULE_NOT_DELETED THEN
1251:
1252: ROLLBACK TO update_item_wrap;
1253: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
1254: FND_MSG_PUB.Add;
1255: x_return_status := FND_API.G_RET_STS_ERROR ;
1256:
1257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1261: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');

1257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1258:
1259: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
1260: ROLLBACK TO update_item_wrap;
1261: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
1262: FND_MSG_PUB.Add;
1263: x_return_status := FND_API.G_RET_STS_ERROR ;
1264: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1265:

Line 1269: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_RULE');

1265:
1266:
1267: WHEN IEM_ADMIN_ROUTE_NO_RULE THEN
1268: ROLLBACK TO update_item_wrap;
1269: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_RULE');
1270: FND_MSG_PUB.Add;
1271:
1272: x_return_status := FND_API.G_RET_STS_ERROR ;
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1419: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_DUP_NAME');

1415: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1416:
1417: WHEN IEM_ADMIN_ROUTE_DUP_NAME THEN
1418: ROLLBACK TO update_item_route;
1419: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_DUP_NAME');
1420: FND_MSG_PUB.Add;
1421: x_return_status := FND_API.G_RET_STS_ERROR ;
1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1423:

Line 1426: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');

1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1423:
1424: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
1425: ROLLBACK TO update_item_route;
1426: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
1427: FND_MSG_PUB.Add;
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:

Line 1566: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');

1562: );
1563: EXCEPTION
1564: WHEN IEM_NO_RULE_UPDATE THEN
1565: ROLLBACK TO update_item_rule;
1566: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1567:
1568: FND_MSG_PUB.Add;
1569: x_return_status := FND_API.G_RET_STS_ERROR ;
1570: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1575: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');

1571:
1572: /*
1573: WHEN IEM_INVALID_DATE_FORMAT THEN
1574: ROLLBACK TO update_item_rule;
1575: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
1576: FND_MSG_PUB.Add;
1577: x_return_status := FND_API.G_RET_STS_ERROR ;
1578: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1579: */

Line 1735: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');

1731:
1732: EXCEPTION
1733: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1734: ROLLBACK TO create_wrap_account_routes_PVT;
1735: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1736:
1737: FND_MSG_PUB.Add;
1738: x_return_status := FND_API.G_RET_STS_ERROR ;
1739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1743: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');

1739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1740:
1741: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1742: ROLLBACK TO create_wrap_account_routes_PVT;
1743: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1744: FND_MSG_PUB.Add;
1745:
1746: x_return_status := FND_API.G_RET_STS_ERROR ;
1747: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1752: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');

1748:
1749: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1750:
1751: ROLLBACK TO create_wrap_account_routes_PVT;
1752: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1753: FND_MSG_PUB.Add;
1754: x_return_status := FND_API.G_RET_STS_ERROR ;
1755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1756:

Line 1848: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');

1844: where route_id=p_route_id;
1845:
1846:
1847: IF l_route_cnt = 0 then
1848: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1849:
1850: APP_EXCEPTION.RAISE_EXCEPTION;
1851: END IF;
1852: END IF;

Line 1862: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');

1858: where email_account_id=p_email_account_id;
1859:
1860:
1861: IF l_acct_cnt = 0 then
1862: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1863: APP_EXCEPTION.RAISE_EXCEPTION;
1864:
1865: END IF;
1866: END IF;

Line 1908: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');

1904: );
1905: EXCEPTION
1906: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
1907: ROLLBACK TO update_account_routes_PVT;
1908: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
1909: FND_MSG_PUB.Add;
1910: x_return_status := FND_API.G_RET_STS_ERROR ;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1912: WHEN FND_API.G_EXC_ERROR THEN

Line 2029: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_ROUTE_NOT_DELETED');

2025: ROLLBACK TO delete_acct_route_batch;
2026:
2027:
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_ROUTE_NOT_DELETED');
2030: FND_MSG_PUB.ADD;
2031: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2032:
2033: WHEN FND_API.G_EXC_ERROR THEN

Line 2187: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');

2183: EXCEPTION
2184:
2185: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
2186: ROLLBACK TO update_wrap_acct_routes_1_PVT;
2187: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
2188: FND_MSG_PUB.Add;
2189: x_return_status := FND_API.G_RET_STS_ERROR ;
2190:
2191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2195: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_DELETED');

2191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2192:
2193: WHEN IEM_ACCOUNT_ROUTE_NOT_DELETED THEN
2194: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2195: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_DELETED');
2196: FND_MSG_PUB.Add;
2197: x_return_status := FND_API.G_RET_STS_ERROR ;
2198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2199: WHEN FND_API.G_EXC_ERROR THEN