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 1009: fnd_message.set_name('AR', 'HZ_API_INVALID_ATTRIBUTE');

1005: END IF;
1006: END IF;
1007:
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;

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

1006: END IF;
1007:
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;

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

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

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

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

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

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

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

1589: OPEN c_entity;
1590: FETCH c_entity INTO l_entity_attr_id;
1591:
1592: IF c_entity%NOTFOUND THEN
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;

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

1590: FETCH c_entity INTO l_entity_attr_id;
1591:
1592: IF c_entity%NOTFOUND THEN
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;

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

1591:
1592: IF c_entity%NOTFOUND THEN
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;

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

1682:
1683: WHEN OTHERS THEN
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(

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

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

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

1803: OPEN c_entity;
1804: FETCH c_entity INTO l_entity_attr_id;
1805:
1806: IF c_entity%NOTFOUND THEN
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;

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

1804: FETCH c_entity INTO l_entity_attr_id;
1805:
1806: IF c_entity%NOTFOUND THEN
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;

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

1805:
1806: IF c_entity%NOTFOUND THEN
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;

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

1854: DELETE hz_thirdparty_rule
1855: WHERE entity_attr_id = l_entity_attr_id;
1856:
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;

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

1855: WHERE entity_attr_id = l_entity_attr_id;
1856:
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;

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

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

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

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

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

2065: OPEN c_entity;
2066: FETCH c_entity INTO l_entity_attr_id;
2067:
2068: IF c_entity%NOTFOUND THEN
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;

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

2066: FETCH c_entity INTO l_entity_attr_id;
2067:
2068: IF c_entity%NOTFOUND THEN
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;

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

2067:
2068: IF c_entity%NOTFOUND THEN
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;

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

2106: DELETE hz_select_data_sources
2107: WHERE entity_attr_id = l_entity_attr_id
2108: AND content_source_type = p_data_source_tbl(i);
2109: ELSE
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;

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

2107: WHERE entity_attr_id = l_entity_attr_id
2108: AND content_source_type = p_data_source_tbl(i);
2109: ELSE
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;

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

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

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

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

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

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