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 1012: fnd_msg_pub.add;

1008: IF l_raise_error THEN
1009: fnd_message.set_name('AR', 'HZ_API_INVALID_ATTRIBUTE');
1010: fnd_message.set_token('ATTRIBUTE', p_attribute_name);
1011: fnd_message.set_token('ENTITY', l_name);
1012: fnd_msg_pub.add;
1013: x_return_status := fnd_api.g_ret_sts_error;
1014: END IF;
1015:
1016: -- Debug info.

Line 1389: fnd_msg_pub.initialize;

1385: END IF;
1386:
1387: -- Initialize message list if p_init_msg_list is set to TRUE.
1388: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1389: fnd_msg_pub.initialize;
1390: END IF;
1391:
1392: -- Initialize API return status to success.
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1403: fnd_msg_pub.Count_And_Get(

1399: x_entity_attr_id,
1400: x_return_status );
1401:
1402: -- Standard call to get message count and if count is 1, get message info.
1403: fnd_msg_pub.Count_And_Get(
1404: p_encoded => FND_API.G_FALSE,
1405: p_count => x_msg_count,
1406: p_data => x_msg_data );
1407:

Line 1429: fnd_msg_pub.Count_And_Get(

1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Add_EntityAttribute;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428:
1429: fnd_msg_pub.Count_And_Get(
1430: p_encoded => FND_API.G_FALSE,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data );
1433:

Line 1454: fnd_msg_pub.Count_And_Get(

1450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1451: ROLLBACK TO Add_EntityAttribute;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453:
1454: fnd_msg_pub.Count_And_Get(
1455: p_encoded => FND_API.G_FALSE,
1456: p_count => x_msg_count,
1457: p_data => x_msg_data );
1458:

Line 1481: fnd_msg_pub.add;

1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478:
1479: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1480: fnd_message.set_token('ERROR',SQLERRM);
1481: fnd_msg_pub.add;
1482:
1483: fnd_msg_pub.Count_And_Get(
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,

Line 1483: fnd_msg_pub.Count_And_Get(

1479: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1480: fnd_message.set_token('ERROR',SQLERRM);
1481: fnd_msg_pub.add;
1482:
1483: fnd_msg_pub.Count_And_Get(
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,
1486: p_data => x_msg_data );
1487:

Line 1582: fnd_msg_pub.initialize;

1578: END IF;
1579:
1580: -- Initialize message list if p_init_msg_list is set to TRUE.
1581: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1582: fnd_msg_pub.initialize;
1583: END IF;
1584:
1585: -- Initialize API return status to success.
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1597: fnd_msg_pub.add;

1593: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1594: fnd_message.set_token('RECORD', 'entity attribute');
1595: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1596: NVL(p_attribute_name,'null'||'>'));
1597: fnd_msg_pub.add;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600: CLOSE c_entity;
1601:

Line 1610: fnd_msg_pub.Count_And_Get(

1606:
1607: x_data_source_tbl := l_data_source_tbl;
1608:
1609: -- Standard call to get message count and if count is 1, get message info.
1610: fnd_msg_pub.Count_And_Get(
1611: p_encoded => FND_API.G_FALSE,
1612: p_count => x_msg_count,
1613: p_data => x_msg_data );
1614:

Line 1637: fnd_msg_pub.Count_And_Get(

1633: EXCEPTION
1634: WHEN FND_API.G_EXC_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_ERROR;
1636:
1637: fnd_msg_pub.Count_And_Get(
1638: p_encoded => FND_API.G_FALSE,
1639: p_count => x_msg_count,
1640: p_data => x_msg_data );
1641:

Line 1662: fnd_msg_pub.Count_And_Get(

1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661:
1662: fnd_msg_pub.Count_And_Get(
1663: p_encoded => FND_API.G_FALSE,
1664: p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:

Line 1688: fnd_msg_pub.add;

1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1685:
1686: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1687: fnd_message.set_token('ERROR',SQLERRM);
1688: fnd_msg_pub.add;
1689:
1690: fnd_msg_pub.Count_And_Get(
1691: p_encoded => FND_API.G_FALSE,
1692: p_count => x_msg_count,

Line 1690: fnd_msg_pub.Count_And_Get(

1686: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1687: fnd_message.set_token('ERROR',SQLERRM);
1688: fnd_msg_pub.add;
1689:
1690: fnd_msg_pub.Count_And_Get(
1691: p_encoded => FND_API.G_FALSE,
1692: p_count => x_msg_count,
1693: p_data => x_msg_data );
1694:

Line 1796: fnd_msg_pub.initialize;

1792: END IF;
1793:
1794: -- Initialize message list if p_init_msg_list is set to TRUE.
1795: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1796: fnd_msg_pub.initialize;
1797: END IF;
1798:
1799: -- Initialize API return status to success.
1800: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1811: fnd_msg_pub.add;

1807: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
1808: fnd_message.set_token('RECORD', 'entity attribute');
1809: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
1810: NVL(p_attribute_name,'null'||'>'));
1811: fnd_msg_pub.add;
1812: RAISE FND_API.G_EXC_ERROR;
1813: END IF;
1814: CLOSE c_entity;
1815:

Line 1861: fnd_msg_pub.add;

1857: ELSE
1858: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');
1859: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
1860: NVL(p_attribute_name,'null'||'>'));
1861: fnd_msg_pub.add;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: CLOSE c_selected_data_source;
1865: END LOOP;

Line 1868: fnd_msg_pub.Count_And_Get(

1864: CLOSE c_selected_data_source;
1865: END LOOP;
1866:
1867: -- Standard call to get message count and if count is 1, get message info.
1868: fnd_msg_pub.Count_And_Get(
1869: p_encoded => FND_API.G_FALSE,
1870: p_count => x_msg_count,
1871: p_data => x_msg_data );
1872:

Line 1894: fnd_msg_pub.Count_And_Get(

1890: WHEN FND_API.G_EXC_ERROR THEN
1891: ROLLBACK TO Remove_EntityAttribute;
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893:
1894: fnd_msg_pub.Count_And_Get(
1895: p_encoded => FND_API.G_FALSE,
1896: p_count => x_msg_count,
1897: p_data => x_msg_data );
1898:

Line 1919: fnd_msg_pub.Count_And_Get(

1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: ROLLBACK TO Remove_EntityAttribute;
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918:
1919: fnd_msg_pub.Count_And_Get(
1920: p_encoded => FND_API.G_FALSE,
1921: p_count => x_msg_count,
1922: p_data => x_msg_data );
1923:

Line 1946: fnd_msg_pub.add;

1942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1943:
1944: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1945: fnd_message.set_token('ERROR',SQLERRM);
1946: fnd_msg_pub.add;
1947:
1948: fnd_msg_pub.Count_And_Get(
1949: p_encoded => FND_API.G_FALSE,
1950: p_count => x_msg_count,

Line 1948: fnd_msg_pub.Count_And_Get(

1944: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
1945: fnd_message.set_token('ERROR',SQLERRM);
1946: fnd_msg_pub.add;
1947:
1948: fnd_msg_pub.Count_And_Get(
1949: p_encoded => FND_API.G_FALSE,
1950: p_count => x_msg_count,
1951: p_data => x_msg_data );
1952:

Line 2058: fnd_msg_pub.initialize;

2054: END IF;
2055:
2056: -- Initialize message list if p_init_msg_list is set to TRUE.
2057: IF fnd_api.to_Boolean(p_init_msg_list) THEN
2058: fnd_msg_pub.initialize;
2059: END IF;
2060:
2061: -- Initialize API return status to success.
2062: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2073: fnd_msg_pub.add;

2069: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
2070: fnd_message.set_token('RECORD', 'entity attribute');
2071: fnd_message.set_token('VALUE', '<'||p_entity_name||','||
2072: NVL(p_attribute_name,'null'||'>'));
2073: fnd_msg_pub.add;
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: CLOSE c_entity;
2077:

Line 2114: fnd_msg_pub.add;

2110: fnd_message.set_name('AR', 'HZ_CANNOT_DELETE_ENTITY_SOURCE');
2111: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||
2112: NVL(p_attribute_name,'null'||'>'));
2113: fnd_message.set_token('SOURCE', p_data_source_tbl(i));
2114: fnd_msg_pub.add;
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117: CLOSE c_data_source;
2118: END LOOP;

Line 2147: fnd_msg_pub.Count_And_Get(

2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145:
2146: -- Standard call to get message count and if count is 1, get message info.
2147: fnd_msg_pub.Count_And_Get(
2148: p_encoded => FND_API.G_FALSE,
2149: p_count => x_msg_count,
2150: p_data => x_msg_data );
2151:

Line 2174: fnd_msg_pub.Count_And_Get(

2170: WHEN FND_API.G_EXC_ERROR THEN
2171: ROLLBACK TO Remove_EntityAttrDataSource;
2172: x_return_status := FND_API.G_RET_STS_ERROR;
2173:
2174: fnd_msg_pub.Count_And_Get(
2175: p_encoded => FND_API.G_FALSE,
2176: p_count => x_msg_count,
2177: p_data => x_msg_data );
2178:

Line 2199: fnd_msg_pub.Count_And_Get(

2195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2196: ROLLBACK TO Remove_EntityAttrDataSource;
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198:
2199: fnd_msg_pub.Count_And_Get(
2200: p_encoded => FND_API.G_FALSE,
2201: p_count => x_msg_count,
2202: p_data => x_msg_data );
2203:

Line 2226: fnd_msg_pub.add;

2222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2223:
2224: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2225: fnd_message.set_token('ERROR',SQLERRM);
2226: fnd_msg_pub.add;
2227:
2228: fnd_msg_pub.Count_And_Get(
2229: p_encoded => FND_API.G_FALSE,
2230: p_count => x_msg_count,

Line 2228: fnd_msg_pub.Count_And_Get(

2224: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2225: fnd_message.set_token('ERROR',SQLERRM);
2226: fnd_msg_pub.add;
2227:
2228: fnd_msg_pub.Count_And_Get(
2229: p_encoded => FND_API.G_FALSE,
2230: p_count => x_msg_count,
2231: p_data => x_msg_data );
2232: