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

Line 152: fnd_msg_pub.add;

148: IF curowid%NOTFOUND THEN
149: x_return_status := fnd_api.g_ret_sts_error;
150: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
151: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
152: fnd_msg_pub.add;
153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'No Record found : Error',
155: p_prefix=>'ERROR',
156: p_msg_level=>fnd_log.level_error);

Line 253: fnd_msg_pub.add;

249: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
250: IF g_cp_detail = 'Y' THEN
251: fnd_message.set_name('AR','HZ_LOCATION_UPDATED');
252: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
253: fnd_msg_pub.add;
254: END IF;
255: END IF;
256: CLOSE curowid;
257:

Line 258: fnd_msg_pub.count_and_get(

254: END IF;
255: END IF;
256: CLOSE curowid;
257:
258: fnd_msg_pub.count_and_get(
259: p_encoded => fnd_api.g_false,
260: p_count => x_msg_count,
261: p_data => x_msg_data
262: );

Line 279: -- fnd_msg_pub

275: -- Oracle's eLocation service.
276: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
277: -- hz_utility_v2pub
278: -- fnd_message
279: -- fnd_msg_pub
280: -- MODIFICATION HISTORY
281: -- 01-10-2002 H. Yu Created.
282: -- 03-21-2002 J. del Callar Bug 2252141: Added call to spatial index
283: -- rebuild.

Line 554: fnd_msg_pub.initialize;

550:
551:
552: x_return_status := fnd_api.g_ret_sts_success;
553: l_return_status := fnd_api.g_ret_sts_success;
554: fnd_msg_pub.initialize;
555:
556: retcode := '0';
557: fnd_file.put_line(fnd_file.log,
558: fnd_message.get_string('FND',

Line 1404: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1400: RAISE exchttp;
1401: END IF;
1402:
1403: IF l_return_status = fnd_api.g_ret_sts_error THEN
1404: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1405: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);
1406: trace_handler(msg);
1407: END LOOP;
1408: -- J. del Callar: Re-initialize the stack for the next set.

Line 1405: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);

1401: END IF;
1402:
1403: IF l_return_status = fnd_api.g_ret_sts_error THEN
1404: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1405: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);
1406: trace_handler(msg);
1407: END LOOP;
1408: -- J. del Callar: Re-initialize the stack for the next set.
1409: fnd_msg_pub.initialize;

Line 1409: fnd_msg_pub.initialize;

1405: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);
1406: trace_handler(msg);
1407: END LOOP;
1408: -- J. del Callar: Re-initialize the stack for the next set.
1409: fnd_msg_pub.initialize;
1410: status_handler(l_return_status, x_return_status);
1411: END IF;
1412:
1413: FOR j IN 1..l_array.COUNT LOOP

Line 1601: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1597: END IF;
1598:
1599: -- J. del Callar, bug 2252141: changed to always print out NOCOPY the message
1600: -- stack.
1601: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1602: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256)
1603: || fnd_global.local_chr(10);
1604: trace_handler(msg);
1605: END LOOP;

Line 1602: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256)

1598:
1599: -- J. del Callar, bug 2252141: changed to always print out NOCOPY the message
1600: -- stack.
1601: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1602: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256)
1603: || fnd_global.local_chr(10);
1604: trace_handler(msg);
1605: END LOOP;
1606: fnd_message.clear;

Line 1637: fnd_msg_pub.add;

1633:
1634: EXCEPTION
1635: WHEN expect_http_ad THEN
1636: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');
1637: fnd_msg_pub.add;
1638: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1639: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1640: fnd_global.local_chr(10);
1641: trace_handler(msg);

Line 1638: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1634: EXCEPTION
1635: WHEN expect_http_ad THEN
1636: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');
1637: fnd_msg_pub.add;
1638: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1639: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1640: fnd_global.local_chr(10);
1641: trace_handler(msg);
1642: END LOOP;

Line 1639: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

1635: WHEN expect_http_ad THEN
1636: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');
1637: fnd_msg_pub.add;
1638: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1639: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1640: fnd_global.local_chr(10);
1641: trace_handler(msg);
1642: END LOOP;
1643: fnd_message.clear;

Line 1656: fnd_msg_pub.add;

1652:
1653: WHEN port_number THEN
1654: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
1655: fnd_message.set_token('PORT', l_port);
1656: fnd_msg_pub.add;
1657: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1658: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1659: fnd_global.local_chr(10);
1660: trace_handler(msg);

Line 1657: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1653: WHEN port_number THEN
1654: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
1655: fnd_message.set_token('PORT', l_port);
1656: fnd_msg_pub.add;
1657: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1658: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1659: fnd_global.local_chr(10);
1660: trace_handler(msg);
1661: END LOOP;

Line 1658: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

1654: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
1655: fnd_message.set_token('PORT', l_port);
1656: fnd_msg_pub.add;
1657: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1658: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1659: fnd_global.local_chr(10);
1660: trace_handler(msg);
1661: END LOOP;
1662: fnd_message.clear;

Line 1674: fnd_msg_pub.add;

1670: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1671:
1672: WHEN nlsnumexp THEN
1673: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
1674: fnd_msg_pub.add;
1675: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1676: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1677: fnd_global.local_chr(10);
1678: trace_handler(msg);

Line 1675: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1671:
1672: WHEN nlsnumexp THEN
1673: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
1674: fnd_msg_pub.add;
1675: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1676: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1677: fnd_global.local_chr(10);
1678: trace_handler(msg);
1679: END LOOP;

Line 1676: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

1672: WHEN nlsnumexp THEN
1673: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
1674: fnd_msg_pub.add;
1675: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1676: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1677: fnd_global.local_chr(10);
1678: trace_handler(msg);
1679: END LOOP;
1680: fnd_message.clear;

Line 1692: fnd_msg_pub.add;

1688: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1689:
1690: WHEN atleastonerow THEN
1691: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
1692: fnd_msg_pub.add;
1693: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1694: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1695: fnd_global.local_chr(10);
1696: trace_handler(msg);

Line 1693: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1689:
1690: WHEN atleastonerow THEN
1691: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
1692: fnd_msg_pub.add;
1693: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1694: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1695: fnd_global.local_chr(10);
1696: trace_handler(msg);
1697: END LOOP;

Line 1694: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

1690: WHEN atleastonerow THEN
1691: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
1692: fnd_msg_pub.add;
1693: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1694: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1695: fnd_global.local_chr(10);
1696: trace_handler(msg);
1697: END LOOP;
1698: fnd_message.clear;

Line 1711: fnd_msg_pub.add;

1707:
1708: WHEN morethanmaxrow THEN
1709: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1710: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
1711: fnd_msg_pub.add;
1712: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1713: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1714: fnd_global.local_chr(10);
1715: trace_handler(msg);

Line 1712: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1708: WHEN morethanmaxrow THEN
1709: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1710: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
1711: fnd_msg_pub.add;
1712: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1713: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1714: fnd_global.local_chr(10);
1715: trace_handler(msg);
1716: END LOOP;

Line 1713: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

1709: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
1710: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
1711: fnd_msg_pub.add;
1712: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1713: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1714: fnd_global.local_chr(10);
1715: trace_handler(msg);
1716: END LOOP;
1717: fnd_message.clear;

Line 1728: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1724: retcode := '2';
1725: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1726:
1727: WHEN exchttp THEN
1728: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1729: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1730: fnd_global.local_chr(10);
1731: trace_handler(msg);
1732: END LOOP;

Line 1729: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||

1725: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1726:
1727: WHEN exchttp THEN
1728: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1729: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
1730: fnd_global.local_chr(10);
1731: trace_handler(msg);
1732: END LOOP;
1733: fnd_message.clear;

Line 1768: -- fnd_msg_pub

1764: -- that queries can accurately extract the spatial data.
1765: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1766: -- hz_utility_v2pub
1767: -- fnd_message
1768: -- fnd_msg_pub
1769: -- ARGUMENTS
1770: -- IN:
1771: -- p_concurrent_mode Set to 'Y' if the rebuild is running
1772: -- as its own concurrent program. Set to

Line 1927: fnd_msg_pub.add;

1923: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
1924: ELSE
1925: -- otherwise, just push the error onto the stack.
1926: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');
1927: fnd_msg_pub.add;
1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
1931: p_prefix=>l_debug_prefix,

Line 1958: fnd_msg_pub.add;

1954: fnd_file.put_line(fnd_file.output,
1955: fnd_message.get_string('FND',
1956: 'CONC-CHECK LOG FOR DETAILS'));
1957: ELSE
1958: fnd_msg_pub.add;
1959: END IF;
1960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>g_pkg_name||' Error:',
1962: p_prefix=>'SQL ERROR',