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

Line 175: fnd_msg_pub.add;

171: IF val%FOUND THEN
172: CLOSE val;
173: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
174: fnd_message.set_token('COLUMN', 'location_id');
175: fnd_msg_pub.add;
176: RAISE fnd_api.g_exc_error;
177: END IF;
178: CLOSE val;
179: END IF;

Line 238: l_message_count := fnd_msg_pub.count_msg();

234:
235: if p_location_rec.timezone_id is null or
236: p_location_rec.timezone_id = fnd_api.g_miss_num
237: then
238: l_message_count := fnd_msg_pub.count_msg();
239: hz_timezone_pub.get_timezone_id(
240: p_api_version => 1.0,
241: p_init_msg_list => FND_API.G_FALSE,
242: p_postal_code => p_location_rec.postal_code,

Line 254: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

250: if l_return_status <> fnd_api.g_ret_sts_success
251: then -- we don't raise error
252: l_timezone_id := null;
253: FOR i IN 1..(l_msg_count - l_message_count) LOOP
254: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
255: END LOOP;
256: l_return_status := FND_API.G_RET_STS_SUCCESS;
257: end if;
258: -- fix for bug # 5286032.

Line 542: fnd_msg_pub.add;

538: p_object_version_number = l_object_version_number))
539: THEN
540: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
541: fnd_message.set_token('TABLE', 'hz_locations');
542: fnd_msg_pub.add;
543: RAISE fnd_api.g_exc_error;
544: END IF;
545:
546: p_object_version_number := NVL(l_object_version_number, 1) + 1;

Line 554: fnd_msg_pub.add;

550: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
551: fnd_message.set_token('RECORD', 'location');
552: fnd_message.set_token('VALUE',
553: NVL(TO_CHAR(p_location_rec.location_id),'null'));
554: fnd_msg_pub.add;
555: RAISE fnd_api.g_exc_error;
556: END;
557:
558: -- ACNG

Line 566: FND_MSG_PUB.ADD;

562: IF(l_allow_update_std = 'N' AND
563: l_date_validated IS NOT NULL AND
564: l_validation_status_code IS NOT NULL) THEN
565: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
566: FND_MSG_PUB.ADD;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:
570: IF(p_location_rec.actual_content_source IS NOT NULL) THEN

Line 934: fnd_msg_pub.add;

930: EXCEPTION
931: WHEN OTHERS THEN
932: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
933: fnd_message.set_token('TABLE', 'HZ_PARTIES');
934: fnd_msg_pub.add;
935: CLOSE c1;
936: RAISE fnd_api.g_exc_error;
937: END;
938: END IF; -- location components have been modified

Line 1071: FND_MSG_PUB.initialize;

1067: END IF;
1068:
1069: -- initialize message list if p_init_msg_list is set to TRUE.
1070: IF FND_API.to_Boolean(p_init_msg_list) THEN
1071: FND_MSG_PUB.initialize;
1072: END IF;
1073:
1074: -- initialize API return status to success.
1075: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1180: FND_MSG_PUB.ADD;

1176: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SECURITY_FAIL');
1177: FND_MESSAGE.SET_TOKEN('USER_NAME',fnd_global.user_name);
1178: FND_MESSAGE.SET_TOKEN('OPER_NAME','INSERT');
1179: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','HZ_LOCATIONS');
1180: FND_MSG_PUB.ADD;
1181: RAISE FND_API.G_EXC_ERROR;
1182: END IF;
1183: */
1184:

Line 1209: FND_MSG_PUB.Count_And_Get(

1205: END IF;
1206: END IF;
1207:
1208: -- standard call to get message count and if count is 1, get message info.
1209: FND_MSG_PUB.Count_And_Get(
1210: p_encoded => FND_API.G_FALSE,
1211: p_count => x_msg_count,
1212: p_data => x_msg_data);
1213: -- Debug info.

Line 1233: FND_MSG_PUB.Count_And_Get(

1229: EXCEPTION
1230: WHEN FND_API.G_EXC_ERROR THEN
1231: ROLLBACK TO create_location;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
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 1257: FND_MSG_PUB.Count_And_Get(

1253:
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: ROLLBACK TO create_location;
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: FND_MSG_PUB.Count_And_Get(
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data);
1261:

Line 1284: FND_MSG_PUB.ADD;

1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281:
1282: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1283: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1284: FND_MSG_PUB.ADD;
1285:
1286: FND_MSG_PUB.Count_And_Get(
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,

Line 1286: FND_MSG_PUB.Count_And_Get(

1282: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1283: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1284: FND_MSG_PUB.ADD;
1285:
1286: FND_MSG_PUB.Count_And_Get(
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data);
1290:

Line 1372: FND_MSG_PUB.ADD;

1368: EXCEPTION WHEN OTHERS THEN
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1372: FND_MSG_PUB.ADD;
1373: FND_MSG_PUB.Count_And_Get(
1374: p_encoded => FND_API.G_FALSE,
1375: p_count => x_msg_count,
1376: p_data => x_msg_data);

Line 1373: FND_MSG_PUB.Count_And_Get(

1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1371: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1372: FND_MSG_PUB.ADD;
1373: FND_MSG_PUB.Count_And_Get(
1374: p_encoded => FND_API.G_FALSE,
1375: p_count => x_msg_count,
1376: p_data => x_msg_data);
1377: END create_location;

Line 1471: FND_MSG_PUB.initialize;

1467: END IF;
1468:
1469: -- initialize message list if p_init_msg_list is set to TRUE.
1470: IF FND_API.to_Boolean(p_init_msg_list) THEN
1471: FND_MSG_PUB.initialize;
1472: END IF;
1473:
1474: -- initialize API return status to success.
1475: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1539: FND_MSG_PUB.ADD;

1535: --
1536: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
1537: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1538: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1539: FND_MSG_PUB.ADD;
1540: RAISE FND_API.G_EXC_ERROR;
1541: END IF;
1542: END IF;
1543: END IF;

Line 1621: l_message_count := fnd_msg_pub.count_msg();

1617: if p_location_rec.state IS NULL
1618: then
1619: l_location_rec.state := l_old_location_rec.state;
1620: end if;
1621: l_message_count := fnd_msg_pub.count_msg();
1622: hz_timezone_pub.get_timezone_id(
1623: p_api_version => 1.0,
1624: p_init_msg_list => FND_API.G_FALSE,
1625: p_postal_code => l_location_rec.postal_code,

Line 1637: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

1633: if l_return_status <> fnd_api.g_ret_sts_success
1634: then -- we don't raise error
1635: l_location_rec.timezone_id := fnd_api.g_miss_num;
1636: FOR i IN 1..(l_msg_count - l_message_count) LOOP
1637: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
1638: END LOOP;
1639: l_return_status := FND_API.G_RET_STS_SUCCESS;
1640: end if;
1641: end if;

Line 1726: FND_MSG_PUB.Count_And_Get(

1722:
1723: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1724:
1725: -- standard call to get message count and if count is 1, get message info.
1726: FND_MSG_PUB.Count_And_Get(
1727: p_encoded => FND_API.G_FALSE,
1728: p_count => x_msg_count,
1729: p_data => x_msg_data);
1730:

Line 1753: FND_MSG_PUB.Count_And_Get(

1749: WHEN FND_API.G_EXC_ERROR THEN
1750: ROLLBACK TO update_location;
1751: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1752: x_return_status := FND_API.G_RET_STS_ERROR;
1753: FND_MSG_PUB.Count_And_Get(
1754: p_encoded => FND_API.G_FALSE,
1755: p_count => x_msg_count,
1756: p_data => x_msg_data);
1757:

Line 1778: FND_MSG_PUB.Count_And_Get(

1774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1775: ROLLBACK TO update_location;
1776: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1778: FND_MSG_PUB.Count_And_Get(
1779: p_encoded => FND_API.G_FALSE,
1780: p_count => x_msg_count,
1781: p_data => x_msg_data);
1782:

Line 1806: FND_MSG_PUB.ADD;

1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803:
1804: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1806: FND_MSG_PUB.ADD;
1807:
1808: FND_MSG_PUB.Count_And_Get(
1809: p_encoded => FND_API.G_FALSE,
1810: p_count => x_msg_count,

Line 1808: FND_MSG_PUB.Count_And_Get(

1804: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1805: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1806: FND_MSG_PUB.ADD;
1807:
1808: FND_MSG_PUB.Count_And_Get(
1809: p_encoded => FND_API.G_FALSE,
1810: p_count => x_msg_count,
1811: p_data => x_msg_data);
1812:

Line 1895: FND_MSG_PUB.ADD;

1891: EXCEPTION WHEN OTHERS THEN
1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: FND_MSG_PUB.Count_And_Get(
1897: p_encoded => FND_API.G_FALSE,
1898: p_count => x_msg_count,
1899: p_data => x_msg_data);

Line 1896: FND_MSG_PUB.Count_And_Get(

1892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1893: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1894: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1895: FND_MSG_PUB.ADD;
1896: FND_MSG_PUB.Count_And_Get(
1897: p_encoded => FND_API.G_FALSE,
1898: p_count => x_msg_count,
1899: p_data => x_msg_data);
1900: END update_location;

Line 1960: fnd_msg_pub.initialize;

1956: END IF;
1957:
1958: -- Initialize message list if p_init_msg_list is set to TRUE.
1959: IF fnd_api.to_boolean(p_init_msg_list) THEN
1960: fnd_msg_pub.initialize;
1961: END IF;
1962:
1963: -- Initialize API return status to success.
1964: x_return_status := fnd_api.g_ret_sts_success;

Line 1971: fnd_msg_pub.add;

1967: IF p_location_id IS NULL OR
1968: p_location_id = fnd_api.g_miss_num THEN
1969: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
1970: fnd_message.set_token('COLUMN', 'location_id');
1971: fnd_msg_pub.add;
1972: RAISE fnd_api.g_exc_error;
1973: END IF;
1974:
1975: x_location_rec.location_id := p_location_id;

Line 2061: fnd_msg_pub.count_and_get(

2057: p_msg_level=>fnd_log.level_procedure);
2058: END IF;
2059:
2060: --Standard call to get message count and if count is 1, get message info.
2061: fnd_msg_pub.count_and_get(
2062: p_encoded => fnd_api.g_false,
2063: p_count => x_msg_count,
2064: p_data => x_msg_data
2065: );

Line 2085: fnd_msg_pub.count_and_get(

2081: --disable_debug;
2082: EXCEPTION
2083: WHEN fnd_api.g_exc_error THEN
2084: x_return_status := fnd_api.g_ret_sts_error;
2085: fnd_msg_pub.count_and_get(
2086: p_encoded => fnd_api.g_false,
2087: p_count => x_msg_count,
2088: p_data => x_msg_data
2089: );

Line 2110: fnd_msg_pub.count_and_get(

2106:
2107: WHEN fnd_api.g_exc_unexpected_error THEN
2108: x_return_status := fnd_api.g_ret_sts_unexp_error;
2109:
2110: fnd_msg_pub.count_and_get(
2111: p_encoded => fnd_api.g_false,
2112: p_count => x_msg_count,
2113: p_data => x_msg_data
2114: );

Line 2137: fnd_msg_pub.add;

2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134:
2135: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2136: fnd_message.set_token('ERROR' ,SQLERRM);
2137: fnd_msg_pub.add;
2138:
2139: fnd_msg_pub.count_and_get(
2140: p_encoded => fnd_api.g_false,
2141: p_count => x_msg_count,

Line 2139: fnd_msg_pub.count_and_get(

2135: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2136: fnd_message.set_token('ERROR' ,SQLERRM);
2137: fnd_msg_pub.add;
2138:
2139: fnd_msg_pub.count_and_get(
2140: p_encoded => fnd_api.g_false,
2141: p_count => x_msg_count,
2142: p_data => x_msg_data
2143: );

Line 2350: FND_MSG_PUB.ADD;

2346: p_location_rec.floor <> p_old_location_rec.floor)
2347: THEN
2348: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2349: FND_MESSAGE.SET_TOKEN('COLUMN', 'floor');
2350: FND_MSG_PUB.ADD;
2351: x_return_status := FND_API.G_RET_STS_ERROR;
2352: END IF;
2353:
2354: -- check house_number

Line 2364: FND_MSG_PUB.ADD;

2360: p_location_rec.house_number <> p_old_location_rec.house_number)
2361: THEN
2362: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2363: FND_MESSAGE.SET_TOKEN('COLUMN', 'house_number');
2364: FND_MSG_PUB.ADD;
2365: x_return_status := FND_API.G_RET_STS_ERROR;
2366: END IF;
2367:
2368: -- check po_box_number

Line 2378: FND_MSG_PUB.ADD;

2374: p_location_rec.po_box_number <> p_old_location_rec.po_box_number)
2375: THEN
2376: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2377: FND_MESSAGE.SET_TOKEN('COLUMN', 'po_box_number');
2378: FND_MSG_PUB.ADD;
2379: x_return_status := FND_API.G_RET_STS_ERROR;
2380: END IF;
2381:
2382: -- check street

Line 2392: FND_MSG_PUB.ADD;

2388: p_location_rec.street <> p_old_location_rec.street)
2389: THEN
2390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2391: FND_MESSAGE.SET_TOKEN('COLUMN', 'street');
2392: FND_MSG_PUB.ADD;
2393: x_return_status := FND_API.G_RET_STS_ERROR;
2394: END IF;
2395:
2396: -- check street_number

Line 2406: FND_MSG_PUB.ADD;

2402: p_location_rec.street_number <> p_old_location_rec.street_number)
2403: THEN
2404: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2405: FND_MESSAGE.SET_TOKEN('COLUMN', 'street_number');
2406: FND_MSG_PUB.ADD;
2407: x_return_status := FND_API.G_RET_STS_ERROR;
2408: END IF;
2409:
2410: -- check street_suffix

Line 2420: FND_MSG_PUB.ADD;

2416: p_location_rec.street_suffix <> p_old_location_rec.street_suffix)
2417: THEN
2418: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2419: FND_MESSAGE.SET_TOKEN('COLUMN', 'street_suffix');
2420: FND_MSG_PUB.ADD;
2421: x_return_status := FND_API.G_RET_STS_ERROR;
2422: END IF;
2423:
2424: -- check suite

Line 2434: FND_MSG_PUB.ADD;

2430: p_location_rec.suite <> p_old_location_rec.suite)
2431: THEN
2432: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2433: FND_MESSAGE.SET_TOKEN('COLUMN', 'suite');
2434: FND_MSG_PUB.ADD;
2435: x_return_status := FND_API.G_RET_STS_ERROR;
2436: END IF;
2437:
2438: END check_obsolete_columns;