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 268: FND_MSG_PUB.ADD;

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

Line 296: fnd_msg_pub.add;

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

Line 317: fnd_msg_pub.add;

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

Line 527: FND_MSG_PUB.ADD;

523: p_cont_object_version_number = l_object_version_number ) )
524: THEN
525: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
526: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );
527: FND_MSG_PUB.ADD;
528: RAISE FND_API.G_EXC_ERROR;
529: END IF;
530:
531: p_cont_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 539: FND_MSG_PUB.ADD;

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

Line 566: FND_MSG_PUB.ADD;

562: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
563: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
564: FND_MESSAGE.SET_TOKEN( 'VALUE',
565: NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END;
569: END IF;
570: -- call for validations.

Line 733: FND_MSG_PUB.ADD;

729: WHEN NO_DATA_FOUND THEN
730: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
731: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
732: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END;
736:
737: p_org_contact_rec.party_rel_rec.object_type := 'ORGANIZATION';

Line 827: FND_MSG_PUB.ADD;

823: WHERE ORG_CONTACT_ROLE_ID = l_org_contact_role_id;
824:
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
826: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');
827: FND_MSG_PUB.ADD;
828: RAISE FND_API.G_EXC_ERROR;
829:
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN

Line 1029: FND_MSG_PUB.ADD;

1025: p_object_version_number = l_object_version_number ) )
1026: THEN
1027: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');
1029: FND_MSG_PUB.ADD;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 1039: FND_MSG_PUB.ADD;

1035: EXCEPTION WHEN NO_DATA_FOUND THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1037: FND_MESSAGE.SET_TOKEN('RECORD', 'contact role');
1038: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR(p_org_contact_role_rec.org_contact_role_id ), 'null' ) );
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: END;
1042:
1043: -- call for validations.

Line 1174: FND_MSG_PUB.initialize;

1170: END IF;
1171:
1172: -- initialize message list if p_init_msg_list is set to TRUE.
1173: IF FND_API.to_Boolean(p_init_msg_list) THEN
1174: FND_MSG_PUB.initialize;
1175: END IF;
1176:
1177: -- initialize API return status to success.
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1225: FND_MSG_PUB.Count_And_Get(

1221: IF (p_org_contact_rec.orig_system IS NULL OR p_org_contact_rec.orig_system=FND_API.G_MISS_CHAR) THEN
1222: HZ_DQM_SYNC.sync_contact(l_org_contact_rec.org_contact_id, 'C');
1223: END IF;
1224: -- standard call to get message count and if count is 1, get message info.
1225: FND_MSG_PUB.Count_And_Get(
1226: p_encoded => FND_API.G_FALSE,
1227: p_count => x_msg_count,
1228: p_data => x_msg_data);
1229:

Line 1250: FND_MSG_PUB.Count_And_Get(

1246: EXCEPTION
1247: WHEN FND_API.G_EXC_ERROR THEN
1248: ROLLBACK TO create_org_contact;
1249: x_return_status := FND_API.G_RET_STS_ERROR;
1250: FND_MSG_PUB.Count_And_Get(
1251: p_encoded => FND_API.G_FALSE,
1252: p_count => x_msg_count,
1253: p_data => x_msg_data);
1254:

Line 1275: FND_MSG_PUB.Count_And_Get(

1271:
1272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1273: ROLLBACK TO create_org_contact;
1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1275: FND_MSG_PUB.Count_And_Get(
1276: p_encoded => FND_API.G_FALSE,
1277: p_count => x_msg_count,
1278: p_data => x_msg_data);
1279:

Line 1301: FND_MSG_PUB.ADD;

1297: ROLLBACK TO create_org_contact;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1301: FND_MSG_PUB.ADD;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data);

Line 1302: FND_MSG_PUB.Count_And_Get(

1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1301: FND_MSG_PUB.ADD;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data);
1306:

Line 1393: FND_MSG_PUB.initialize;

1389: END IF;
1390:
1391: -- initialize message list if p_init_msg_list is set to TRUE.
1392: IF FND_API.to_Boolean(p_init_msg_list) THEN
1393: FND_MSG_PUB.initialize;
1394: END IF;
1395:
1396: -- initialize API return status to success.
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1474: FND_MSG_PUB.Count_And_Get(

1470: -- Call to indicate Org Contact update to DQM
1471: HZ_DQM_SYNC.sync_contact(l_org_contact_rec.org_contact_id, 'U');
1472:
1473: -- standard call to get message count and if count is 1, get message info.
1474: FND_MSG_PUB.Count_And_Get(
1475: p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data);
1478:

Line 1498: FND_MSG_PUB.Count_And_Get(

1494: EXCEPTION
1495: WHEN FND_API.G_EXC_ERROR THEN
1496: ROLLBACK TO update_org_contact;
1497: x_return_status := FND_API.G_RET_STS_ERROR;
1498: FND_MSG_PUB.Count_And_Get(
1499: p_encoded => FND_API.G_FALSE,
1500: p_count => x_msg_count,
1501: p_data => x_msg_data);
1502:

Line 1522: FND_MSG_PUB.Count_And_Get(

1518:
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: ROLLBACK TO update_org_contact;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1522: FND_MSG_PUB.Count_And_Get(
1523: p_encoded => FND_API.G_FALSE,
1524: p_count => x_msg_count,
1525: p_data => x_msg_data);
1526:

Line 1548: FND_MSG_PUB.ADD;

1544: ROLLBACK TO update_org_contact;
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1547: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1548: FND_MSG_PUB.ADD;
1549: FND_MSG_PUB.Count_And_Get(
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => x_msg_count,
1552: p_data => x_msg_data);

Line 1549: FND_MSG_PUB.Count_And_Get(

1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1547: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1548: FND_MSG_PUB.ADD;
1549: FND_MSG_PUB.Count_And_Get(
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => x_msg_count,
1552: p_data => x_msg_data);
1553:

Line 1633: FND_MSG_PUB.initialize;

1629: END IF;
1630:
1631: -- initialize message list if p_init_msg_list is set to TRUE.
1632: IF FND_API.to_Boolean(p_init_msg_list) THEN
1633: FND_MSG_PUB.initialize;
1634: END IF;
1635:
1636: -- initialize API return status to success.
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1661: FND_MSG_PUB.Count_And_Get(

1657: END IF;
1658: END IF;
1659:
1660: -- standard call to get message count and if count is 1, get message info.
1661: FND_MSG_PUB.Count_And_Get(
1662: p_encoded => FND_API.G_FALSE,
1663: p_count => x_msg_count,
1664: p_data => x_msg_data);
1665:

Line 1686: FND_MSG_PUB.Count_And_Get(

1682: EXCEPTION
1683: WHEN FND_API.G_EXC_ERROR THEN
1684: ROLLBACK TO create_org_contact_role;
1685: x_return_status := FND_API.G_RET_STS_ERROR;
1686: FND_MSG_PUB.Count_And_Get(
1687: p_encoded => FND_API.G_FALSE,
1688: p_count => x_msg_count,
1689: p_data => x_msg_data);
1690:

Line 1710: FND_MSG_PUB.Count_And_Get(

1706:
1707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1708: ROLLBACK TO create_org_contact_role;
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: FND_MSG_PUB.Count_And_Get(
1711: p_encoded => FND_API.G_FALSE,
1712: p_count => x_msg_count,
1713: p_data => x_msg_data);
1714:

Line 1736: FND_MSG_PUB.ADD;

1732: ROLLBACK TO create_org_contact_role;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_encoded => FND_API.G_FALSE,
1739: p_count => x_msg_count,
1740: p_data => x_msg_data);

Line 1737: FND_MSG_PUB.Count_And_Get(

1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_encoded => FND_API.G_FALSE,
1739: p_count => x_msg_count,
1740: p_data => x_msg_data);
1741:

Line 1822: FND_MSG_PUB.initialize;

1818: END IF;
1819:
1820: -- initialize message list if p_init_msg_list is set to TRUE.
1821: IF FND_API.to_Boolean(p_init_msg_list) THEN
1822: FND_MSG_PUB.initialize;
1823: END IF;
1824:
1825: -- initialize API return status to success.
1826: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1881: FND_MSG_PUB.Count_And_Get(

1877: END IF;
1878: END IF;
1879:
1880: -- standard call to get message count and if count is 1, get message info.
1881: FND_MSG_PUB.Count_And_Get(
1882: p_encoded => FND_API.G_FALSE,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885:

Line 1906: FND_MSG_PUB.Count_And_Get(

1902: EXCEPTION
1903: WHEN FND_API.G_EXC_ERROR THEN
1904: ROLLBACK TO update_org_contact_role;
1905: x_return_status := FND_API.G_RET_STS_ERROR;
1906: FND_MSG_PUB.Count_And_Get(
1907: p_encoded => FND_API.G_FALSE,
1908: p_count => x_msg_count,
1909: p_data => x_msg_data);
1910:

Line 1930: FND_MSG_PUB.Count_And_Get(

1926:
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: ROLLBACK TO update_org_contact_role;
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: FND_MSG_PUB.Count_And_Get(
1931: p_encoded => FND_API.G_FALSE,
1932: p_count => x_msg_count,
1933: p_data => x_msg_data);
1934:

Line 1956: FND_MSG_PUB.ADD;

1952: ROLLBACK TO update_org_contact_role;
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1955: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1956: FND_MSG_PUB.ADD;
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,
1959: p_count => x_msg_count,
1960: p_data => x_msg_data);

Line 1957: FND_MSG_PUB.Count_And_Get(

1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1955: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1956: FND_MSG_PUB.ADD;
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,
1959: p_count => x_msg_count,
1960: p_data => x_msg_data);
1961:

Line 2029: FND_MSG_PUB.initialize;

2025: BEGIN
2026:
2027: --Initialize message list if p_init_msg_list is set to TRUE.
2028: IF FND_API.to_Boolean(p_init_msg_list) THEN
2029: FND_MSG_PUB.initialize;
2030: END IF;
2031:
2032: --Initialize API return status to success.
2033: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2039: FND_MSG_PUB.ADD;

2035: IF p_org_contact_id IS NULL OR
2036: p_org_contact_id = FND_API.G_MISS_NUM THEN
2037: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2038: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_id' );
2039: FND_MSG_PUB.ADD;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;
2042:
2043: x_org_contact_rec.org_contact_id := p_org_contact_id;

Line 2113: FND_MSG_PUB.Count_And_Get(

2109: END IF;
2110: END IF;
2111:
2112: --Standard call to get message count and if count is 1, get message info.
2113: FND_MSG_PUB.Count_And_Get(
2114: p_encoded => FND_API.G_FALSE,
2115: p_count => x_msg_count,
2116: p_data => x_msg_data );
2117:

Line 2122: FND_MSG_PUB.Count_And_Get(

2118: EXCEPTION
2119: WHEN FND_API.G_EXC_ERROR THEN
2120: x_return_status := FND_API.G_RET_STS_ERROR;
2121:
2122: FND_MSG_PUB.Count_And_Get(
2123: p_encoded => FND_API.G_FALSE,
2124: p_count => x_msg_count,
2125: p_data => x_msg_data );
2126:

Line 2130: FND_MSG_PUB.Count_And_Get(

2126:
2127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2128: x_return_status := FND_API.G_RET_STS_UNEXP_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 2139: FND_MSG_PUB.ADD;

2135: WHEN OTHERS THEN
2136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2138: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2139: FND_MSG_PUB.ADD;
2140: FND_MSG_PUB.Count_And_Get(
2141: p_encoded => FND_API.G_FALSE,
2142: p_count => x_msg_count,
2143: p_data => x_msg_data );

Line 2140: FND_MSG_PUB.Count_And_Get(

2136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2138: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2139: FND_MSG_PUB.ADD;
2140: FND_MSG_PUB.Count_And_Get(
2141: p_encoded => FND_API.G_FALSE,
2142: p_count => x_msg_count,
2143: p_data => x_msg_data );
2144:

Line 2191: FND_MSG_PUB.initialize;

2187: BEGIN
2188:
2189: --Initialize message list if p_init_msg_list is set to TRUE.
2190: IF FND_API.to_Boolean(p_init_msg_list) THEN
2191: FND_MSG_PUB.initialize;
2192: END IF;
2193:
2194: --Initialize API return status to success.
2195: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2202: FND_MSG_PUB.ADD;

2198: IF p_org_contact_role_id IS NULL OR
2199: p_org_contact_role_id = FND_API.G_MISS_NUM THEN
2200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2201: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_role_id' );
2202: FND_MSG_PUB.ADD;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;
2205:
2206: x_org_contact_role_rec.org_contact_role_id := p_org_contact_role_id;

Line 2222: FND_MSG_PUB.Count_And_Get(

2218: X_APPLICATION_ID => x_org_contact_role_rec.application_id
2219: );
2220:
2221: --Standard call to get message count and if count is 1, get message info.
2222: FND_MSG_PUB.Count_And_Get(
2223: p_encoded => FND_API.G_FALSE,
2224: p_count => x_msg_count,
2225: p_data => x_msg_data );
2226:

Line 2231: FND_MSG_PUB.Count_And_Get(

2227: EXCEPTION
2228: WHEN FND_API.G_EXC_ERROR THEN
2229: x_return_status := FND_API.G_RET_STS_ERROR;
2230:
2231: FND_MSG_PUB.Count_And_Get(
2232: p_encoded => FND_API.G_FALSE,
2233: p_count => x_msg_count,
2234: p_data => x_msg_data );
2235:

Line 2239: FND_MSG_PUB.Count_And_Get(

2235:
2236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2237: x_return_status := FND_API.G_RET_STS_UNEXP_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 2249: FND_MSG_PUB.ADD;

2245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2246:
2247: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2248: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2249: FND_MSG_PUB.ADD;
2250:
2251: FND_MSG_PUB.Count_And_Get(
2252: p_encoded => FND_API.G_FALSE,
2253: p_count => x_msg_count,

Line 2251: FND_MSG_PUB.Count_And_Get(

2247: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2248: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2249: FND_MSG_PUB.ADD;
2250:
2251: FND_MSG_PUB.Count_And_Get(
2252: p_encoded => FND_API.G_FALSE,
2253: p_count => x_msg_count,
2254: p_data => x_msg_data );
2255:

Line 2291: FND_MSG_PUB.ADD;

2287: p_org_contact_rec.title <> p_old_org_contact_rec.title)
2288: THEN
2289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2290: FND_MESSAGE.SET_TOKEN('COLUMN', 'title');
2291: FND_MSG_PUB.ADD;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: END IF;
2294:
2295: END check_obsolete_columns;