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_API

Line 67: IF x_return_status = fnd_api.g_ret_sts_error THEN

63: l_return_status IN VARCHAR2,
64: x_return_status IN OUT NOCOPY VARCHAR2
65: ) IS
66: BEGIN
67: IF x_return_status = fnd_api.g_ret_sts_error THEN
68: NULL;
69: ELSIF x_return_status = 'W'
70: AND l_return_status = fnd_api.g_ret_sts_success
71: THEN

Line 70: AND l_return_status = fnd_api.g_ret_sts_success

66: BEGIN
67: IF x_return_status = fnd_api.g_ret_sts_error THEN
68: NULL;
69: ELSIF x_return_status = 'W'
70: AND l_return_status = fnd_api.g_ret_sts_success
71: THEN
72: NULL;
73: ELSE
74: x_return_status := l_return_status;

Line 149: x_return_status := fnd_api.g_ret_sts_error;

145: END IF;
146: OPEN curowid;
147: FETCH curowid INTO l_rowid;
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

Line 259: p_encoded => fnd_api.g_false,

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: );
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 552: x_return_status := fnd_api.g_ret_sts_success;

548: END IF;
549:
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';

Line 553: l_return_status := fnd_api.g_ret_sts_success;

549:
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,

Line 1248: l_return_status := fnd_api.g_ret_sts_unexp_error;

1244: END IF; -- cu_loc3b/cu_loc3bc, check if p_country is null or not
1245: END IF;
1246:
1247: ELSE
1248: l_return_status := fnd_api.g_ret_sts_unexp_error;
1249: time_put_line('Unexpected mode encountered');
1250: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'Unexpected mode encountered',
1252: p_prefix=>'ERROR',

Line 1333: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1329: x_msg_count => x_msg_count,
1330: x_msg_data => x_msg_data
1331: );
1332:
1333: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1334: time_put_line('Unexpected error encountered');
1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1336: hz_utility_v2pub.debug(p_message=>'Unexpected error encountered',
1337: p_prefix=>'ERROR',

Line 1403: IF l_return_status = fnd_api.g_ret_sts_error THEN

1399: l_array.DELETE;
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;

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 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 1608: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1604: trace_handler(msg);
1605: END LOOP;
1606: fnd_message.clear;
1607:
1608: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1609: retcode := '1';
1610: -- J. del Callar: instruct user to look at log if warnings are found.
1611: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1612: fnd_file.put_line(fnd_file.output, errbuf);

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 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 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 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 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 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;