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_PARTY_CONTACT_V2PUB dependencies on FND_MSG_PUB

Line 209: FND_MSG_PUB.ADD;

205: WHERE ORG_CONTACT_ID = l_org_contact_id;
206:
207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
208: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_id');
209: FND_MSG_PUB.ADD;
210: RAISE FND_API.G_EXC_ERROR;
211:
212: EXCEPTION
213: WHEN NO_DATA_FOUND THEN

Line 271: FND_MSG_PUB.ADD;

267: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
268: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
269: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
270: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: CLOSE c_rel;
275:

Line 299: fnd_msg_pub.add;

295: EXCEPTION
296: WHEN OTHERS THEN
297: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
298: fnd_message.set_token('TABLE', 'HZ_PARTIES');
299: fnd_msg_pub.add;
300: RAISE FND_API.G_EXC_ERROR;
301: END;
302: IF l_person_pre_name IS NULL THEN
303: UPDATE hz_parties

Line 320: fnd_msg_pub.add;

316: EXCEPTION
317: WHEN OTHERS THEN
318: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
319: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
320: fnd_msg_pub.add;
321: RAISE FND_API.G_EXC_ERROR;
322: END;
323: UPDATE hz_person_profiles
324: SET person_pre_name_adjunct = p_org_contact_rec.title

Line 532: FND_MSG_PUB.ADD;

528: p_cont_object_version_number = l_object_version_number ) )
529: THEN
530: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
531: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:
536: p_cont_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 544: FND_MSG_PUB.ADD;

540: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
541: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org contact' );
542: FND_MESSAGE.SET_TOKEN( 'VALUE',
543: NVL( TO_CHAR( p_org_contact_rec.org_contact_id ), 'null' ) );
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END;
547: --Bug Fix 2188731
548: IF p_org_contact_rec.party_rel_rec.relationship_id IS NOT NULL THEN

Line 571: FND_MSG_PUB.ADD;

567: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
568: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
569: FND_MESSAGE.SET_TOKEN( 'VALUE',
570: NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
571: FND_MSG_PUB.ADD;
572: RAISE FND_API.G_EXC_ERROR;
573: END;
574: END IF;
575: -- call for validations.

Line 738: FND_MSG_PUB.ADD;

734: WHEN NO_DATA_FOUND THEN
735: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
736: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
737: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
738: FND_MSG_PUB.ADD;
739: RAISE FND_API.G_EXC_ERROR;
740: END;
741:
742: p_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';

Line 832: FND_MSG_PUB.ADD;

828: WHERE ORG_CONTACT_ROLE_ID = l_org_contact_role_id;
829:
830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
831: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');
832: FND_MSG_PUB.ADD;
833: RAISE FND_API.G_EXC_ERROR;
834:
835: EXCEPTION
836: WHEN NO_DATA_FOUND THEN

Line 1034: FND_MSG_PUB.ADD;

1030: p_object_version_number = l_object_version_number ) )
1031: THEN
1032: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1033: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');
1034: FND_MSG_PUB.ADD;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1044: FND_MSG_PUB.ADD;

1040: EXCEPTION WHEN NO_DATA_FOUND THEN
1041: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1042: FND_MESSAGE.SET_TOKEN('RECORD', 'contact role');
1043: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR(p_org_contact_role_rec.org_contact_role_id ), 'null' ) );
1044: FND_MSG_PUB.ADD;
1045: RAISE FND_API.G_EXC_ERROR;
1046: END;
1047:
1048: -- call for validations.

Line 1179: FND_MSG_PUB.initialize;

1175: END IF;
1176:
1177: -- initialize message list if p_init_msg_list is set to TRUE.
1178: IF FND_API.to_Boolean(p_init_msg_list) THEN
1179: FND_MSG_PUB.initialize;
1180: END IF;
1181:
1182: -- initialize API return status to success.
1183: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1233: FND_MSG_PUB.Count_And_Get(

1229: HZ_DQM_SYNC.sync_contact(l_org_contact_rec.org_contact_id, 'C');
1230: END IF;
1231: */
1232: -- standard call to get message count and if count is 1, get message info.
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_msg_count,
1236: p_data => x_msg_data);
1237:

Line 1258: FND_MSG_PUB.Count_And_Get(

1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: ROLLBACK TO create_org_contact;
1257: x_return_status := FND_API.G_RET_STS_ERROR;
1258: FND_MSG_PUB.Count_And_Get(
1259: p_encoded => FND_API.G_FALSE,
1260: p_count => x_msg_count,
1261: p_data => x_msg_data);
1262:

Line 1283: FND_MSG_PUB.Count_And_Get(

1279:
1280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1281: ROLLBACK TO create_org_contact;
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: FND_MSG_PUB.Count_And_Get(
1284: p_encoded => FND_API.G_FALSE,
1285: p_count => x_msg_count,
1286: p_data => x_msg_data);
1287:

Line 1309: FND_MSG_PUB.ADD;

1305: ROLLBACK TO create_org_contact;
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1308: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1309: FND_MSG_PUB.ADD;
1310: FND_MSG_PUB.Count_And_Get(
1311: p_encoded => FND_API.G_FALSE,
1312: p_count => x_msg_count,
1313: p_data => x_msg_data);

Line 1310: FND_MSG_PUB.Count_And_Get(

1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1308: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1309: FND_MSG_PUB.ADD;
1310: FND_MSG_PUB.Count_And_Get(
1311: p_encoded => FND_API.G_FALSE,
1312: p_count => x_msg_count,
1313: p_data => x_msg_data);
1314:

Line 1401: FND_MSG_PUB.initialize;

1397: END IF;
1398:
1399: -- initialize message list if p_init_msg_list is set to TRUE.
1400: IF FND_API.to_Boolean(p_init_msg_list) THEN
1401: FND_MSG_PUB.initialize;
1402: END IF;
1403:
1404: -- initialize API return status to success.
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1482: FND_MSG_PUB.Count_And_Get(

1478: -- Call to indicate Org Contact update to DQM
1479: HZ_DQM_SYNC.sync_contact(l_org_contact_rec.org_contact_id, 'U');
1480:
1481: -- standard call to get message count and if count is 1, get message info.
1482: FND_MSG_PUB.Count_And_Get(
1483: p_encoded => FND_API.G_FALSE,
1484: p_count => x_msg_count,
1485: p_data => x_msg_data);
1486:

Line 1506: FND_MSG_PUB.Count_And_Get(

1502: EXCEPTION
1503: WHEN FND_API.G_EXC_ERROR THEN
1504: ROLLBACK TO update_org_contact;
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: FND_MSG_PUB.Count_And_Get(
1507: p_encoded => FND_API.G_FALSE,
1508: p_count => x_msg_count,
1509: p_data => x_msg_data);
1510:

Line 1530: FND_MSG_PUB.Count_And_Get(

1526:
1527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1528: ROLLBACK TO update_org_contact;
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: FND_MSG_PUB.Count_And_Get(
1531: p_encoded => FND_API.G_FALSE,
1532: p_count => x_msg_count,
1533: p_data => x_msg_data);
1534:

Line 1556: FND_MSG_PUB.ADD;

1552: ROLLBACK TO update_org_contact;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1556: FND_MSG_PUB.ADD;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => FND_API.G_FALSE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);

Line 1557: FND_MSG_PUB.Count_And_Get(

1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1555: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1556: FND_MSG_PUB.ADD;
1557: FND_MSG_PUB.Count_And_Get(
1558: p_encoded => FND_API.G_FALSE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data);
1561:

Line 1641: FND_MSG_PUB.initialize;

1637: END IF;
1638:
1639: -- initialize message list if p_init_msg_list is set to TRUE.
1640: IF FND_API.to_Boolean(p_init_msg_list) THEN
1641: FND_MSG_PUB.initialize;
1642: END IF;
1643:
1644: -- initialize API return status to success.
1645: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1669: FND_MSG_PUB.Count_And_Get(

1665: END IF;
1666: END IF;
1667:
1668: -- standard call to get message count and if count is 1, get message info.
1669: FND_MSG_PUB.Count_And_Get(
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => x_msg_count,
1672: p_data => x_msg_data);
1673:

Line 1694: FND_MSG_PUB.Count_And_Get(

1690: EXCEPTION
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: ROLLBACK TO create_org_contact_role;
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: FND_MSG_PUB.Count_And_Get(
1695: p_encoded => FND_API.G_FALSE,
1696: p_count => x_msg_count,
1697: p_data => x_msg_data);
1698:

Line 1718: FND_MSG_PUB.Count_And_Get(

1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: ROLLBACK TO create_org_contact_role;
1717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1718: FND_MSG_PUB.Count_And_Get(
1719: p_encoded => FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:

Line 1744: FND_MSG_PUB.ADD;

1740: ROLLBACK TO create_org_contact_role;
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1744: FND_MSG_PUB.ADD;
1745: FND_MSG_PUB.Count_And_Get(
1746: p_encoded => FND_API.G_FALSE,
1747: p_count => x_msg_count,
1748: p_data => x_msg_data);

Line 1745: FND_MSG_PUB.Count_And_Get(

1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1742: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1743: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1744: FND_MSG_PUB.ADD;
1745: FND_MSG_PUB.Count_And_Get(
1746: p_encoded => FND_API.G_FALSE,
1747: p_count => x_msg_count,
1748: p_data => x_msg_data);
1749:

Line 1830: FND_MSG_PUB.initialize;

1826: END IF;
1827:
1828: -- initialize message list if p_init_msg_list is set to TRUE.
1829: IF FND_API.to_Boolean(p_init_msg_list) THEN
1830: FND_MSG_PUB.initialize;
1831: END IF;
1832:
1833: -- initialize API return status to success.
1834: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1889: FND_MSG_PUB.Count_And_Get(

1885: END IF;
1886: END IF;
1887:
1888: -- standard call to get message count and if count is 1, get message info.
1889: FND_MSG_PUB.Count_And_Get(
1890: p_encoded => FND_API.G_FALSE,
1891: p_count => x_msg_count,
1892: p_data => x_msg_data);
1893:

Line 1914: FND_MSG_PUB.Count_And_Get(

1910: EXCEPTION
1911: WHEN FND_API.G_EXC_ERROR THEN
1912: ROLLBACK TO update_org_contact_role;
1913: x_return_status := FND_API.G_RET_STS_ERROR;
1914: FND_MSG_PUB.Count_And_Get(
1915: p_encoded => FND_API.G_FALSE,
1916: p_count => x_msg_count,
1917: p_data => x_msg_data);
1918:

Line 1938: FND_MSG_PUB.Count_And_Get(

1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK TO update_org_contact_role;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: FND_MSG_PUB.Count_And_Get(
1939: p_encoded => FND_API.G_FALSE,
1940: p_count => x_msg_count,
1941: p_data => x_msg_data);
1942:

Line 1964: FND_MSG_PUB.ADD;

1960: ROLLBACK TO update_org_contact_role;
1961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1962: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1964: FND_MSG_PUB.ADD;
1965: FND_MSG_PUB.Count_And_Get(
1966: p_encoded => FND_API.G_FALSE,
1967: p_count => x_msg_count,
1968: p_data => x_msg_data);

Line 1965: FND_MSG_PUB.Count_And_Get(

1961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1962: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1963: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1964: FND_MSG_PUB.ADD;
1965: FND_MSG_PUB.Count_And_Get(
1966: p_encoded => FND_API.G_FALSE,
1967: p_count => x_msg_count,
1968: p_data => x_msg_data);
1969:

Line 2037: FND_MSG_PUB.initialize;

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

Line 2047: FND_MSG_PUB.ADD;

2043: IF p_org_contact_id IS NULL OR
2044: p_org_contact_id = FND_API.G_MISS_NUM THEN
2045: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2046: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_id' );
2047: FND_MSG_PUB.ADD;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;
2050:
2051: x_org_contact_rec.org_contact_id := p_org_contact_id;

Line 2121: FND_MSG_PUB.Count_And_Get(

2117: END IF;
2118: END IF;
2119:
2120: --Standard call to get message count and if count is 1, get message info.
2121: FND_MSG_PUB.Count_And_Get(
2122: p_encoded => FND_API.G_FALSE,
2123: p_count => x_msg_count,
2124: p_data => x_msg_data );
2125:

Line 2130: FND_MSG_PUB.Count_And_Get(

2126: EXCEPTION
2127: WHEN FND_API.G_EXC_ERROR THEN
2128: x_return_status := FND_API.G_RET_STS_ERROR;
2129:
2130: FND_MSG_PUB.Count_And_Get(
2131: p_encoded => FND_API.G_FALSE,
2132: p_count => x_msg_count,
2133: p_data => x_msg_data );
2134:

Line 2138: FND_MSG_PUB.Count_And_Get(

2134:
2135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2137:
2138: FND_MSG_PUB.Count_And_Get(
2139: p_encoded => FND_API.G_FALSE,
2140: p_count => x_msg_count,
2141: p_data => x_msg_data );
2142:

Line 2147: FND_MSG_PUB.ADD;

2143: WHEN OTHERS THEN
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2146: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2147: FND_MSG_PUB.ADD;
2148: FND_MSG_PUB.Count_And_Get(
2149: p_encoded => FND_API.G_FALSE,
2150: p_count => x_msg_count,
2151: p_data => x_msg_data );

Line 2148: FND_MSG_PUB.Count_And_Get(

2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2146: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2147: FND_MSG_PUB.ADD;
2148: FND_MSG_PUB.Count_And_Get(
2149: p_encoded => FND_API.G_FALSE,
2150: p_count => x_msg_count,
2151: p_data => x_msg_data );
2152:

Line 2199: FND_MSG_PUB.initialize;

2195: BEGIN
2196:
2197: --Initialize message list if p_init_msg_list is set to TRUE.
2198: IF FND_API.to_Boolean(p_init_msg_list) THEN
2199: FND_MSG_PUB.initialize;
2200: END IF;
2201:
2202: --Initialize API return status to success.
2203: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2210: FND_MSG_PUB.ADD;

2206: IF p_org_contact_role_id IS NULL OR
2207: p_org_contact_role_id = FND_API.G_MISS_NUM THEN
2208: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2209: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_role_id' );
2210: FND_MSG_PUB.ADD;
2211: RAISE FND_API.G_EXC_ERROR;
2212: END IF;
2213:
2214: x_org_contact_role_rec.org_contact_role_id := p_org_contact_role_id;

Line 2230: FND_MSG_PUB.Count_And_Get(

2226: X_APPLICATION_ID => x_org_contact_role_rec.application_id
2227: );
2228:
2229: --Standard call to get message count and if count is 1, get message info.
2230: FND_MSG_PUB.Count_And_Get(
2231: p_encoded => FND_API.G_FALSE,
2232: p_count => x_msg_count,
2233: p_data => x_msg_data );
2234:

Line 2239: FND_MSG_PUB.Count_And_Get(

2235: EXCEPTION
2236: WHEN FND_API.G_EXC_ERROR THEN
2237: x_return_status := FND_API.G_RET_STS_ERROR;
2238:
2239: FND_MSG_PUB.Count_And_Get(
2240: p_encoded => FND_API.G_FALSE,
2241: p_count => x_msg_count,
2242: p_data => x_msg_data );
2243:

Line 2247: FND_MSG_PUB.Count_And_Get(

2243:
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2246:
2247: FND_MSG_PUB.Count_And_Get(
2248: p_encoded => FND_API.G_FALSE,
2249: p_count => x_msg_count,
2250: p_data => x_msg_data );
2251:

Line 2257: FND_MSG_PUB.ADD;

2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254:
2255: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2256: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2257: FND_MSG_PUB.ADD;
2258:
2259: FND_MSG_PUB.Count_And_Get(
2260: p_encoded => FND_API.G_FALSE,
2261: p_count => x_msg_count,

Line 2259: FND_MSG_PUB.Count_And_Get(

2255: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2256: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2257: FND_MSG_PUB.ADD;
2258:
2259: FND_MSG_PUB.Count_And_Get(
2260: p_encoded => FND_API.G_FALSE,
2261: p_count => x_msg_count,
2262: p_data => x_msg_data );
2263:

Line 2299: FND_MSG_PUB.ADD;

2295: p_org_contact_rec.title <> p_old_org_contact_rec.title)
2296: THEN
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2298: FND_MESSAGE.SET_TOKEN('COLUMN', 'title');
2299: FND_MSG_PUB.ADD;
2300: x_return_status := FND_API.G_RET_STS_ERROR;
2301: END IF;
2302:
2303: END check_obsolete_columns;