DBA Data[Home] [Help]

APPS.HZ_MIXNM_REGISTRY_PUB dependencies on FND_MSG_PUB

Line 735: fnd_msg_pub.add;

731: THEN
732: fnd_message.set_name('AR','HZ_API_COLUMN_SHOULD_BE_NULL');
733: fnd_message.set_token('COLUMN','attribute_name');
734: fnd_message.set_token('TABLE','hz_entity_attributes');
735: fnd_msg_pub.add;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: ELSIF p_entity_attribute_rec.entity_name IN
738: (G_ORG_ENTITY, G_PERSON_ENTITY)
739: THEN

Line 789: fnd_msg_pub.add;

785: -- SSM SST Integration and Extension: data source will be a foreign key in hz_orig_systems_b
786: -- and will not be a lookup of type CONTENT_SOURCE_TYPE.
787: IF p_data_source_tab.COUNT = 0 THEN
788: fnd_message.set_name('AR', 'HZ_API_NO_DATA_SOURCE');
789: fnd_msg_pub.add;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: ELSE
792: FOR i IN 1..p_data_source_tab.COUNT LOOP
793: IF p_data_source_tab(i) IS NULL OR

Line 797: fnd_msg_pub.add;

793: IF p_data_source_tab(i) IS NULL OR
794: p_data_source_tab(i) = 'SST'
795: THEN
796: fnd_message.set_name('AR', 'HZ_API_INVALID_DATA_SOURCE');
797: fnd_msg_pub.add;
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: ELSE
800: /*
801: hz_utility_v2pub.validate_lookup (

Line 825: FND_MSG_PUB.ADD;

821: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');
822: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEM_B');
823: FND_MESSAGE.SET_TOKEN('COLUMN','ORIG_SYSTEM');
824: FND_MESSAGE.SET_TOKEN('FK','DATA SOURCE');
825: FND_MSG_PUB.ADD;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: END IF;
828: END LOOP;
829: CLOSE c_valid_data_source;

Line 990: fnd_msg_pub.add;

986: IF l_raise_error THEN
987: fnd_message.set_name('AR', 'HZ_API_INVALID_ATTRIBUTE');
988: fnd_message.set_token('ATTRIBUTE', p_attribute_name);
989: fnd_message.set_token('ENTITY', l_name);
990: fnd_msg_pub.add;
991: x_return_status := fnd_api.g_ret_sts_error;
992: END IF;
993:
994: -- Debug info.

Line 1367: fnd_msg_pub.initialize;

1363: END IF;
1364:
1365: -- Initialize message list if p_init_msg_list is set to TRUE.
1366: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1367: fnd_msg_pub.initialize;
1368: END IF;
1369:
1370: -- Initialize API return status to success.
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1381: fnd_msg_pub.Count_And_Get(

1377: x_entity_attr_id,
1378: x_return_status );
1379:
1380: -- Standard call to get message count and if count is 1, get message info.
1381: fnd_msg_pub.Count_And_Get(
1382: p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data );
1385:

Line 1407: fnd_msg_pub.Count_And_Get(

1403: WHEN FND_API.G_EXC_ERROR THEN
1404: ROLLBACK TO Add_EntityAttribute;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: fnd_msg_pub.Count_And_Get(
1408: p_encoded => FND_API.G_FALSE,
1409: p_count => x_msg_count,
1410: p_data => x_msg_data );
1411:

Line 1432: fnd_msg_pub.Count_And_Get(

1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: ROLLBACK TO Add_EntityAttribute;
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431:
1432: fnd_msg_pub.Count_And_Get(
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data );
1436:

Line 1459: fnd_msg_pub.add;

1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1456:
1457: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1458: fnd_message.set_token('ERROR',SQLERRM);
1459: fnd_msg_pub.add;
1460:
1461: fnd_msg_pub.Count_And_Get(
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => x_msg_count,

Line 1461: fnd_msg_pub.Count_And_Get(

1457: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1458: fnd_message.set_token('ERROR',SQLERRM);
1459: fnd_msg_pub.add;
1460:
1461: fnd_msg_pub.Count_And_Get(
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => x_msg_count,
1464: p_data => x_msg_data );
1465:

Line 1560: fnd_msg_pub.initialize;

1556: END IF;
1557:
1558: -- Initialize message list if p_init_msg_list is set to TRUE.
1559: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1560: fnd_msg_pub.initialize;
1561: END IF;
1562:
1563: -- Initialize API return status to success.
1564: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1575: fnd_msg_pub.add;

1571: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1572: fnd_message.set_token('RECORD', 'entity attribute');
1573: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1574: NVL(p_attribute_name,'null'||'>'));
1575: fnd_msg_pub.add;
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578: CLOSE c_entity;
1579:

Line 1588: fnd_msg_pub.Count_And_Get(

1584:
1585: x_data_source_tbl := l_data_source_tbl;
1586:
1587: -- Standard call to get message count and if count is 1, get message info.
1588: fnd_msg_pub.Count_And_Get(
1589: p_encoded => FND_API.G_FALSE,
1590: p_count => x_msg_count,
1591: p_data => x_msg_data );
1592:

Line 1615: fnd_msg_pub.Count_And_Get(

1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614:
1615: fnd_msg_pub.Count_And_Get(
1616: p_encoded => FND_API.G_FALSE,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data );
1619:

Line 1640: fnd_msg_pub.Count_And_Get(

1636:
1637: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639:
1640: fnd_msg_pub.Count_And_Get(
1641: p_encoded => FND_API.G_FALSE,
1642: p_count => x_msg_count,
1643: p_data => x_msg_data );
1644:

Line 1666: fnd_msg_pub.add;

1662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1663:
1664: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1665: fnd_message.set_token('ERROR',SQLERRM);
1666: fnd_msg_pub.add;
1667:
1668: fnd_msg_pub.Count_And_Get(
1669: p_encoded => FND_API.G_FALSE,
1670: p_count => x_msg_count,

Line 1668: fnd_msg_pub.Count_And_Get(

1664: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1665: fnd_message.set_token('ERROR',SQLERRM);
1666: fnd_msg_pub.add;
1667:
1668: fnd_msg_pub.Count_And_Get(
1669: p_encoded => FND_API.G_FALSE,
1670: p_count => x_msg_count,
1671: p_data => x_msg_data );
1672:

Line 1774: fnd_msg_pub.initialize;

1770: END IF;
1771:
1772: -- Initialize message list if p_init_msg_list is set to TRUE.
1773: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1774: fnd_msg_pub.initialize;
1775: END IF;
1776:
1777: -- Initialize API return status to success.
1778: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1789: fnd_msg_pub.add;

1785: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1786: fnd_message.set_token('RECORD', 'entity attribute');
1787: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1788: NVL(p_attribute_name,'null'||'>'));
1789: fnd_msg_pub.add;
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792: CLOSE c_entity;
1793:

Line 1839: fnd_msg_pub.add;

1835: ELSE
1836: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');
1837: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
1838: NVL(p_attribute_name,'null'||'>'));
1839: fnd_msg_pub.add;
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842: CLOSE c_selected_data_source;
1843: END LOOP;

Line 1846: fnd_msg_pub.Count_And_Get(

1842: CLOSE c_selected_data_source;
1843: END LOOP;
1844:
1845: -- Standard call to get message count and if count is 1, get message info.
1846: fnd_msg_pub.Count_And_Get(
1847: p_encoded => FND_API.G_FALSE,
1848: p_count => x_msg_count,
1849: p_data => x_msg_data );
1850:

Line 1872: fnd_msg_pub.Count_And_Get(

1868: WHEN FND_API.G_EXC_ERROR THEN
1869: ROLLBACK TO Remove_EntityAttribute;
1870: x_return_status := FND_API.G_RET_STS_ERROR;
1871:
1872: fnd_msg_pub.Count_And_Get(
1873: p_encoded => FND_API.G_FALSE,
1874: p_count => x_msg_count,
1875: p_data => x_msg_data );
1876:

Line 1897: fnd_msg_pub.Count_And_Get(

1893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1894: ROLLBACK TO Remove_EntityAttribute;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896:
1897: fnd_msg_pub.Count_And_Get(
1898: p_encoded => FND_API.G_FALSE,
1899: p_count => x_msg_count,
1900: p_data => x_msg_data );
1901:

Line 1924: fnd_msg_pub.add;

1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921:
1922: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1923: fnd_message.set_token('ERROR',SQLERRM);
1924: fnd_msg_pub.add;
1925:
1926: fnd_msg_pub.Count_And_Get(
1927: p_encoded => FND_API.G_FALSE,
1928: p_count => x_msg_count,

Line 1926: fnd_msg_pub.Count_And_Get(

1922: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1923: fnd_message.set_token('ERROR',SQLERRM);
1924: fnd_msg_pub.add;
1925:
1926: fnd_msg_pub.Count_And_Get(
1927: p_encoded => FND_API.G_FALSE,
1928: p_count => x_msg_count,
1929: p_data => x_msg_data );
1930:

Line 2036: fnd_msg_pub.initialize;

2032: END IF;
2033:
2034: -- Initialize message list if p_init_msg_list is set to TRUE.
2035: IF fnd_api.to_Boolean(p_init_msg_list) THEN
2036: fnd_msg_pub.initialize;
2037: END IF;
2038:
2039: -- Initialize API return status to success.
2040: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2051: fnd_msg_pub.add;

2047: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2048: fnd_message.set_token('RECORD', 'entity attribute');
2049: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
2050: NVL(p_attribute_name,'null'||'>'));
2051: fnd_msg_pub.add;
2052: RAISE FND_API.G_EXC_ERROR;
2053: END IF;
2054: CLOSE c_entity;
2055:

Line 2092: fnd_msg_pub.add;

2088: fnd_message.set_name('AR', 'HZ_CANNOT_DELETE_ENTITY_SOURCE');
2089: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
2090: NVL(p_attribute_name,'null'||'>'));
2091: fnd_message.set_token('SOURCE', p_data_source_tbl(i));
2092: fnd_msg_pub.add;
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095: CLOSE c_data_source;
2096: END LOOP;

Line 2125: fnd_msg_pub.Count_And_Get(

2121: RAISE FND_API.G_EXC_ERROR;
2122: END IF;
2123:
2124: -- Standard call to get message count and if count is 1, get message info.
2125: fnd_msg_pub.Count_And_Get(
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data );
2129:

Line 2152: fnd_msg_pub.Count_And_Get(

2148: WHEN FND_API.G_EXC_ERROR THEN
2149: ROLLBACK TO Remove_EntityAttrDataSource;
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151:
2152: fnd_msg_pub.Count_And_Get(
2153: p_encoded => FND_API.G_FALSE,
2154: p_count => x_msg_count,
2155: p_data => x_msg_data );
2156:

Line 2177: fnd_msg_pub.Count_And_Get(

2173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2174: ROLLBACK TO Remove_EntityAttrDataSource;
2175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2176:
2177: fnd_msg_pub.Count_And_Get(
2178: p_encoded => FND_API.G_FALSE,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data );
2181:

Line 2204: fnd_msg_pub.add;

2200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2201:
2202: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2203: fnd_message.set_token('ERROR',SQLERRM);
2204: fnd_msg_pub.add;
2205:
2206: fnd_msg_pub.Count_And_Get(
2207: p_encoded => FND_API.G_FALSE,
2208: p_count => x_msg_count,

Line 2206: fnd_msg_pub.Count_And_Get(

2202: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2203: fnd_message.set_token('ERROR',SQLERRM);
2204: fnd_msg_pub.add;
2205:
2206: fnd_msg_pub.Count_And_Get(
2207: p_encoded => FND_API.G_FALSE,
2208: p_count => x_msg_count,
2209: p_data => x_msg_data );
2210: