eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MIXNM_REGISTRY_PUB dependencies on FND_MESSAGE

Line 732: fnd_message.set_name('AR','HZ_API_COLUMN_SHOULD_BE_NULL');

728: (G_ORG_ENTITY, G_PERSON_ENTITY) AND
729: p_entity_attribute_rec.attribute_name IS NOT NULL AND
730: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
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;

Line 733: fnd_message.set_token('COLUMN','attribute_name');

729: p_entity_attribute_rec.attribute_name IS NOT NULL AND
730: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
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

Line 734: fnd_message.set_token('TABLE','hz_entity_attributes');

730: p_entity_attribute_rec.attribute_name <> FND_API.G_MISS_CHAR
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)

Line 788: fnd_message.set_name('AR', 'HZ_API_NO_DATA_SOURCE');

784:
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

Line 796: fnd_message.set_name('AR', 'HZ_API_INVALID_DATA_SOURCE');

792: FOR i IN 1..p_data_source_tab.COUNT LOOP
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: /*

Line 821: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_FK');

817: FETCH c_valid_data_source
818: INTO l_dummy;
819:
820: IF c_valid_data_source%NOTFOUND THEN
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;

Line 822: FND_MESSAGE.SET_TOKEN('TABLE','HZ_ORIG_SYSTEM_B');

818: INTO l_dummy;
819:
820: IF c_valid_data_source%NOTFOUND THEN
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;

Line 823: FND_MESSAGE.SET_TOKEN('COLUMN','ORIG_SYSTEM');

819:
820: IF c_valid_data_source%NOTFOUND THEN
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;

Line 824: FND_MESSAGE.SET_TOKEN('FK','DATA SOURCE');

820: IF c_valid_data_source%NOTFOUND THEN
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;

Line 987: fnd_message.set_name('AR', 'HZ_API_INVALID_ATTRIBUTE');

983: END IF;
984: END IF;
985:
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;

Line 988: fnd_message.set_token('ATTRIBUTE', p_attribute_name);

984: END IF;
985:
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;

Line 989: fnd_message.set_token('ENTITY', l_name);

985:
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:

Line 1457: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

1453: WHEN OTHERS THEN
1454: ROLLBACK TO Add_EntityAttribute;
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(

Line 1458: fnd_message.set_token('ERROR',SQLERRM);

1454: ROLLBACK TO Add_EntityAttribute;
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,

Line 1571: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1567: OPEN c_entity;
1568: FETCH c_entity INTO l_entity_attr_id;
1569:
1570: IF c_entity%NOTFOUND THEN
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;

Line 1572: fnd_message.set_token('RECORD', 'entity attribute');

1568: FETCH c_entity INTO l_entity_attr_id;
1569:
1570: IF c_entity%NOTFOUND THEN
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;

Line 1573: fnd_message.set_token('VALUE', '<'||p_entity_name||','||

1569:
1570: IF c_entity%NOTFOUND THEN
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;

Line 1664: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

1660:
1661: WHEN OTHERS THEN
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(

Line 1665: fnd_message.set_token('ERROR',SQLERRM);

1661: WHEN OTHERS THEN
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,

Line 1785: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

1781: OPEN c_entity;
1782: FETCH c_entity INTO l_entity_attr_id;
1783:
1784: IF c_entity%NOTFOUND THEN
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;

Line 1786: fnd_message.set_token('RECORD', 'entity attribute');

1782: FETCH c_entity INTO l_entity_attr_id;
1783:
1784: IF c_entity%NOTFOUND THEN
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;

Line 1787: fnd_message.set_token('VALUE', '<'||p_entity_name||','||

1783:
1784: IF c_entity%NOTFOUND THEN
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;

Line 1836: fnd_message.set_name('AR', 'HZ_API_CANNOT_DELETE_ENTITY');

1832: DELETE hz_thirdparty_rule
1833: WHERE entity_attr_id = l_entity_attr_id;
1834:
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;

Line 1837: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||

1833: WHERE entity_attr_id = l_entity_attr_id;
1834:
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;

Line 1922: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

1918: WHEN OTHERS THEN
1919: ROLLBACK TO Remove_EntityAttribute;
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(

Line 1923: fnd_message.set_token('ERROR',SQLERRM);

1919: ROLLBACK TO Remove_EntityAttribute;
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,

Line 2047: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');

2043: OPEN c_entity;
2044: FETCH c_entity INTO l_entity_attr_id;
2045:
2046: IF c_entity%NOTFOUND THEN
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;

Line 2048: fnd_message.set_token('RECORD', 'entity attribute');

2044: FETCH c_entity INTO l_entity_attr_id;
2045:
2046: IF c_entity%NOTFOUND THEN
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;

Line 2049: fnd_message.set_token('VALUE', '<'||p_entity_name||','||

2045:
2046: IF c_entity%NOTFOUND THEN
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;

Line 2088: fnd_message.set_name('AR', 'HZ_CANNOT_DELETE_ENTITY_SOURCE');

2084: DELETE hz_select_data_sources
2085: WHERE entity_attr_id = l_entity_attr_id
2086: AND content_source_type = p_data_source_tbl(i);
2087: ELSE
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;

Line 2089: fnd_message.set_token('ENTITY_ATTRIBUTE', '<'||p_entity_name||','||

2085: WHERE entity_attr_id = l_entity_attr_id
2086: AND content_source_type = p_data_source_tbl(i);
2087: ELSE
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;

Line 2091: fnd_message.set_token('SOURCE', p_data_source_tbl(i));

2087: ELSE
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;

Line 2202: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');

2198: WHEN OTHERS THEN
2199: ROLLBACK TO Remove_EntityAttrDataSource;
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(

Line 2203: fnd_message.set_token('ERROR',SQLERRM);

2199: ROLLBACK TO Remove_EntityAttrDataSource;
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,