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 241: l_message_count := fnd_msg_pub.count_msg();

237: --Corrected the Index
238: if p_location_rec.timezone_id is null or
239: p_location_rec.timezone_id = fnd_api.g_miss_num
240: then
241: l_message_count := fnd_msg_pub.count_msg();
242: hz_timezone_pub.get_timezone_id(
243: p_api_version => 1.0,
244: p_init_msg_list => FND_API.G_FALSE,
245: p_postal_code => p_location_rec.postal_code,

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

253: if l_return_status <> fnd_api.g_ret_sts_success
254: then -- we don't raise error
255: l_timezone_id := null;
256: /* FOR i IN 1..(l_msg_count - l_message_count) LOOP
257: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
258: END LOOP;
259: */
260: --Bug#8616119
261: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 267: fnd_msg_pub.delete_msg(i);

263: p_prefix =>l_debug_prefix,
264: p_msg_level=>fnd_log.level_statement);
265: END IF;
266: FOR i IN REVERSE (l_message_count + 1)..l_msg_count LOOP
267: fnd_msg_pub.delete_msg(i);
268: END LOOP;
269: l_return_status := FND_API.G_RET_STS_SUCCESS;
270: end if;
271: -- fix for bug # 5286032.

Line 555: fnd_msg_pub.add;

551: p_object_version_number = l_object_version_number))
552: THEN
553: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
554: fnd_message.set_token('TABLE', 'hz_locations');
555: fnd_msg_pub.add;
556: RAISE fnd_api.g_exc_error;
557: END IF;
558:
559: p_object_version_number := NVL(l_object_version_number, 1) + 1;

Line 567: fnd_msg_pub.add;

563: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
564: fnd_message.set_token('RECORD', 'location');
565: fnd_message.set_token('VALUE',
566: NVL(TO_CHAR(p_location_rec.location_id),'null'));
567: fnd_msg_pub.add;
568: RAISE fnd_api.g_exc_error;
569: END;
570:
571: -- ACNG

Line 579: FND_MSG_PUB.ADD;

575: IF(l_allow_update_std = 'N' AND
576: l_date_validated IS NOT NULL AND
577: l_validation_status_code IS NOT NULL) THEN
578: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
579: FND_MSG_PUB.ADD;
580: RAISE fnd_api.g_exc_error;
581: END IF;
582:
583: IF(p_location_rec.actual_content_source IS NOT NULL) THEN

Line 947: fnd_msg_pub.add;

943: EXCEPTION
944: WHEN OTHERS THEN
945: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
946: fnd_message.set_token('TABLE', 'HZ_PARTIES');
947: fnd_msg_pub.add;
948: CLOSE c1;
949: RAISE fnd_api.g_exc_error;
950: END;
951: END IF; -- location components have been modified

Line 1084: FND_MSG_PUB.initialize;

1080: END IF;
1081:
1082: -- initialize message list if p_init_msg_list is set to TRUE.
1083: IF FND_API.to_Boolean(p_init_msg_list) THEN
1084: FND_MSG_PUB.initialize;
1085: END IF;
1086:
1087: -- initialize API return status to success.
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1193: FND_MSG_PUB.ADD;

1189: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_SECURITY_FAIL');
1190: FND_MESSAGE.SET_TOKEN('USER_NAME',fnd_global.user_name);
1191: FND_MESSAGE.SET_TOKEN('OPER_NAME','INSERT');
1192: FND_MESSAGE.SET_TOKEN('OBJECT_NAME','HZ_LOCATIONS');
1193: FND_MSG_PUB.ADD;
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196: */
1197:

Line 1222: FND_MSG_PUB.Count_And_Get(

1218: END IF;
1219: END IF;
1220:
1221: -- standard call to get message count and if count is 1, get message info.
1222: FND_MSG_PUB.Count_And_Get(
1223: p_encoded => FND_API.G_FALSE,
1224: p_count => x_msg_count,
1225: p_data => x_msg_data);
1226: -- Debug info.

Line 1246: FND_MSG_PUB.Count_And_Get(

1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: ROLLBACK TO create_location;
1245: x_return_status := FND_API.G_RET_STS_ERROR;
1246: FND_MSG_PUB.Count_And_Get(
1247: p_encoded => FND_API.G_FALSE,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data);
1250:

Line 1270: FND_MSG_PUB.Count_And_Get(

1266:
1267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1268: ROLLBACK TO create_location;
1269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1270: FND_MSG_PUB.Count_And_Get(
1271: p_encoded => FND_API.G_FALSE,
1272: p_count => x_msg_count,
1273: p_data => x_msg_data);
1274:

Line 1297: FND_MSG_PUB.ADD;

1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294:
1295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1296: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1297: FND_MSG_PUB.ADD;
1298:
1299: FND_MSG_PUB.Count_And_Get(
1300: p_encoded => FND_API.G_FALSE,
1301: p_count => x_msg_count,

Line 1299: FND_MSG_PUB.Count_And_Get(

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

Line 1385: FND_MSG_PUB.ADD;

1381: EXCEPTION WHEN OTHERS THEN
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1383: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1385: FND_MSG_PUB.ADD;
1386: FND_MSG_PUB.Count_And_Get(
1387: p_encoded => FND_API.G_FALSE,
1388: p_count => x_msg_count,
1389: p_data => x_msg_data);

Line 1386: FND_MSG_PUB.Count_And_Get(

1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1383: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1384: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1385: FND_MSG_PUB.ADD;
1386: FND_MSG_PUB.Count_And_Get(
1387: p_encoded => FND_API.G_FALSE,
1388: p_count => x_msg_count,
1389: p_data => x_msg_data);
1390: END create_location;

Line 1484: FND_MSG_PUB.initialize;

1480: END IF;
1481:
1482: -- initialize message list if p_init_msg_list is set to TRUE.
1483: IF FND_API.to_Boolean(p_init_msg_list) THEN
1484: FND_MSG_PUB.initialize;
1485: END IF;
1486:
1487: -- initialize API return status to success.
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1552: FND_MSG_PUB.ADD;

1548: --
1549: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
1550: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
1551: fnd_message.get_string('AR', 'HZ_DSS_PARTY_ADDRESSES'));
1552: FND_MSG_PUB.ADD;
1553: RAISE FND_API.G_EXC_ERROR;
1554: END IF;
1555: END IF;
1556: END IF;

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

1635: if p_location_rec.state IS NULL
1636: then
1637: l_location_rec.state := l_old_location_rec.state;
1638: end if;
1639: l_message_count := fnd_msg_pub.count_msg();
1640: hz_timezone_pub.get_timezone_id(
1641: p_api_version => 1.0,
1642: p_init_msg_list => FND_API.G_FALSE,
1643: p_postal_code => l_location_rec.postal_code,

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

1656: if l_return_status <> fnd_api.g_ret_sts_success
1657: then -- we don't raise error
1658: l_location_rec.timezone_id := fnd_api.g_miss_num;
1659: /* FOR i IN 1..(l_msg_count - l_message_count) LOOP
1660: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
1661: END LOOP;
1662: */--Bug#8616119
1663: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'TimeZone Id not found. Messages are deleted from msg stack',

Line 1669: fnd_msg_pub.delete_msg(i);

1665: p_prefix =>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_statement);
1667: END IF;
1668: FOR i IN REVERSE (l_message_count + 1)..l_msg_count LOOP
1669: fnd_msg_pub.delete_msg(i);
1670: END LOOP;
1671: l_return_status := FND_API.G_RET_STS_SUCCESS;
1672: end if;
1673: end if;

Line 1758: FND_MSG_PUB.Count_And_Get(

1754:
1755: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1756:
1757: -- standard call to get message count and if count is 1, get message info.
1758: FND_MSG_PUB.Count_And_Get(
1759: p_encoded => FND_API.G_FALSE,
1760: p_count => x_msg_count,
1761: p_data => x_msg_data);
1762:

Line 1785: FND_MSG_PUB.Count_And_Get(

1781: WHEN FND_API.G_EXC_ERROR THEN
1782: ROLLBACK TO update_location;
1783: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_encoded => FND_API.G_FALSE,
1787: p_count => x_msg_count,
1788: p_data => x_msg_data);
1789:

Line 1810: FND_MSG_PUB.Count_And_Get(

1806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1807: ROLLBACK TO update_location;
1808: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FND_MSG_PUB.Count_And_Get(
1811: p_encoded => FND_API.G_FALSE,
1812: p_count => x_msg_count,
1813: p_data => x_msg_data);
1814:

Line 1838: FND_MSG_PUB.ADD;

1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835:
1836: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1838: FND_MSG_PUB.ADD;
1839:
1840: FND_MSG_PUB.Count_And_Get(
1841: p_encoded => FND_API.G_FALSE,
1842: p_count => x_msg_count,

Line 1840: FND_MSG_PUB.Count_And_Get(

1836: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1837: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1838: FND_MSG_PUB.ADD;
1839:
1840: FND_MSG_PUB.Count_And_Get(
1841: p_encoded => FND_API.G_FALSE,
1842: p_count => x_msg_count,
1843: p_data => x_msg_data);
1844:

Line 1927: FND_MSG_PUB.ADD;

1923: EXCEPTION WHEN OTHERS THEN
1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);

Line 1928: FND_MSG_PUB.Count_And_Get(

1924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1926: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1927: FND_MSG_PUB.ADD;
1928: FND_MSG_PUB.Count_And_Get(
1929: p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932: END update_location;

Line 1992: fnd_msg_pub.initialize;

1988: END IF;
1989:
1990: -- Initialize message list if p_init_msg_list is set to TRUE.
1991: IF fnd_api.to_boolean(p_init_msg_list) THEN
1992: fnd_msg_pub.initialize;
1993: END IF;
1994:
1995: -- Initialize API return status to success.
1996: x_return_status := fnd_api.g_ret_sts_success;

Line 2003: fnd_msg_pub.add;

1999: IF p_location_id IS NULL OR
2000: p_location_id = fnd_api.g_miss_num THEN
2001: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
2002: fnd_message.set_token('COLUMN', 'location_id');
2003: fnd_msg_pub.add;
2004: RAISE fnd_api.g_exc_error;
2005: END IF;
2006:
2007: x_location_rec.location_id := p_location_id;

Line 2093: fnd_msg_pub.count_and_get(

2089: p_msg_level=>fnd_log.level_procedure);
2090: END IF;
2091:
2092: --Standard call to get message count and if count is 1, get message info.
2093: fnd_msg_pub.count_and_get(
2094: p_encoded => fnd_api.g_false,
2095: p_count => x_msg_count,
2096: p_data => x_msg_data
2097: );

Line 2117: fnd_msg_pub.count_and_get(

2113: --disable_debug;
2114: EXCEPTION
2115: WHEN fnd_api.g_exc_error THEN
2116: x_return_status := fnd_api.g_ret_sts_error;
2117: fnd_msg_pub.count_and_get(
2118: p_encoded => fnd_api.g_false,
2119: p_count => x_msg_count,
2120: p_data => x_msg_data
2121: );

Line 2142: fnd_msg_pub.count_and_get(

2138:
2139: WHEN fnd_api.g_exc_unexpected_error THEN
2140: x_return_status := fnd_api.g_ret_sts_unexp_error;
2141:
2142: fnd_msg_pub.count_and_get(
2143: p_encoded => fnd_api.g_false,
2144: p_count => x_msg_count,
2145: p_data => x_msg_data
2146: );

Line 2169: fnd_msg_pub.add;

2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2166:
2167: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2168: fnd_message.set_token('ERROR' ,SQLERRM);
2169: fnd_msg_pub.add;
2170:
2171: fnd_msg_pub.count_and_get(
2172: p_encoded => fnd_api.g_false,
2173: p_count => x_msg_count,

Line 2171: fnd_msg_pub.count_and_get(

2167: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2168: fnd_message.set_token('ERROR' ,SQLERRM);
2169: fnd_msg_pub.add;
2170:
2171: fnd_msg_pub.count_and_get(
2172: p_encoded => fnd_api.g_false,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data
2175: );

Line 2382: FND_MSG_PUB.ADD;

2378: p_location_rec.floor <> p_old_location_rec.floor)
2379: THEN
2380: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2381: FND_MESSAGE.SET_TOKEN('COLUMN', 'floor');
2382: FND_MSG_PUB.ADD;
2383: x_return_status := FND_API.G_RET_STS_ERROR;
2384: END IF;
2385:
2386: -- check house_number

Line 2396: FND_MSG_PUB.ADD;

2392: p_location_rec.house_number <> p_old_location_rec.house_number)
2393: THEN
2394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2395: FND_MESSAGE.SET_TOKEN('COLUMN', 'house_number');
2396: FND_MSG_PUB.ADD;
2397: x_return_status := FND_API.G_RET_STS_ERROR;
2398: END IF;
2399:
2400: -- check po_box_number

Line 2410: FND_MSG_PUB.ADD;

2406: p_location_rec.po_box_number <> p_old_location_rec.po_box_number)
2407: THEN
2408: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2409: FND_MESSAGE.SET_TOKEN('COLUMN', 'po_box_number');
2410: FND_MSG_PUB.ADD;
2411: x_return_status := FND_API.G_RET_STS_ERROR;
2412: END IF;
2413:
2414: -- check street

Line 2424: FND_MSG_PUB.ADD;

2420: p_location_rec.street <> p_old_location_rec.street)
2421: THEN
2422: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2423: FND_MESSAGE.SET_TOKEN('COLUMN', 'street');
2424: FND_MSG_PUB.ADD;
2425: x_return_status := FND_API.G_RET_STS_ERROR;
2426: END IF;
2427:
2428: -- check street_number

Line 2438: FND_MSG_PUB.ADD;

2434: p_location_rec.street_number <> p_old_location_rec.street_number)
2435: THEN
2436: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2437: FND_MESSAGE.SET_TOKEN('COLUMN', 'street_number');
2438: FND_MSG_PUB.ADD;
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: END IF;
2441:
2442: -- check street_suffix

Line 2452: FND_MSG_PUB.ADD;

2448: p_location_rec.street_suffix <> p_old_location_rec.street_suffix)
2449: THEN
2450: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2451: FND_MESSAGE.SET_TOKEN('COLUMN', 'street_suffix');
2452: FND_MSG_PUB.ADD;
2453: x_return_status := FND_API.G_RET_STS_ERROR;
2454: END IF;
2455:
2456: -- check suite

Line 2466: FND_MSG_PUB.ADD;

2462: p_location_rec.suite <> p_old_location_rec.suite)
2463: THEN
2464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2465: FND_MESSAGE.SET_TOKEN('COLUMN', 'suite');
2466: FND_MSG_PUB.ADD;
2467: x_return_status := FND_API.G_RET_STS_ERROR;
2468: END IF;
2469:
2470: END check_obsolete_columns;