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 556: x_return_status := fnd_api.g_ret_sts_success;

552: END IF;
553:
554:
555:
556: x_return_status := fnd_api.g_ret_sts_success;
557: l_return_status := fnd_api.g_ret_sts_success;
558: fnd_msg_pub.initialize;
559:
560: retcode := '0';

Line 557: l_return_status := fnd_api.g_ret_sts_success;

553:
554:
555:
556: x_return_status := fnd_api.g_ret_sts_success;
557: l_return_status := fnd_api.g_ret_sts_success;
558: fnd_msg_pub.initialize;
559:
560: retcode := '0';
561: fnd_file.put_line(fnd_file.log,

Line 1252: l_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1337: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

Line 1407: IF l_return_status = fnd_api.g_ret_sts_error THEN

1403: l_array.DELETE;
1404: RAISE exchttp;
1405: END IF;
1406:
1407: IF l_return_status = fnd_api.g_ret_sts_error THEN
1408: FOR j IN 1..fnd_msg_pub.count_msg LOOP
1409: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);
1410: trace_handler(msg);
1411: END LOOP;

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

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

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

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

Line 1612: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2033: x_return_status := fnd_api.g_ret_sts_success;

2029: p_prefix=>l_debug_prefix,
2030: p_msg_level=>fnd_log.level_procedure);
2031: END IF;
2032:
2033: x_return_status := fnd_api.g_ret_sts_success;
2034: l_return_status := fnd_api.g_ret_sts_success;
2035: fnd_msg_pub.initialize;
2036:
2037: retcode := '0';

Line 2034: l_return_status := fnd_api.g_ret_sts_success;

2030: p_msg_level=>fnd_log.level_procedure);
2031: END IF;
2032:
2033: x_return_status := fnd_api.g_ret_sts_success;
2034: l_return_status := fnd_api.g_ret_sts_success;
2035: fnd_msg_pub.initialize;
2036:
2037: retcode := '0';
2038: fnd_file.put_line(fnd_file.log,

Line 2147: l_return_status := fnd_api.g_ret_sts_unexp_error;

2143: END IF;
2144:
2145: --Location Type is having invalid value.
2146: IF p_loc_type IS NOT NULL AND p_loc_type <> 'P' AND p_loc_type <> 'S' THEN
2147: l_return_status := fnd_api.g_ret_sts_unexp_error;
2148: time_put_line('Unexpected mode encountered');
2149: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'Unexpected mode encountered Invalid Location Type Value',
2151: p_prefix=>'ERROR',

Line 2332: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2328: x_msg_count => x_msg_count,
2329: x_msg_data => x_msg_data
2330: );
2331: -- When Unexpected Error Occurs
2332: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2333: time_put_line('Unexpected error encountered');
2334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2335: hz_utility_v2pub.debug(p_message=>'Unexpected error encountered',
2336: p_prefix=>'ERROR',

Line 2347: IF l_return_status = fnd_api.g_ret_sts_error THEN

2343: l_array.DELETE;
2344: RAISE exchttp;
2345: END IF;
2346:
2347: IF l_return_status = fnd_api.g_ret_sts_error THEN
2348: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2349: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);
2350: trace_handler(msg);
2351: END LOOP;

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

2345: END IF;
2346:
2347: IF l_return_status = fnd_api.g_ret_sts_error THEN
2348: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2349: msg := SUBSTRB(fnd_msg_pub.get(j, fnd_api.g_false),1,256);
2350: trace_handler(msg);
2351: END LOOP;
2352: -- J. del Callar: Re-initialize the stack for the next set.
2353: fnd_msg_pub.initialize;

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

2511: /* Commented in part of ER#10211310
2512: --bug 2252141: changed to always print out NOCOPY the message
2513: -- stack.
2514: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2515: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256)
2516: || fnd_global.local_chr(10);
2517: trace_handler(msg);
2518: END LOOP;
2519: fnd_message.clear;

Line 2521: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2517: trace_handler(msg);
2518: END LOOP;
2519: fnd_message.clear;
2520: */
2521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2522: retcode := '1';
2523: -- Instruct user to look at log if warnings are found.
2524: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2525: fnd_file.put_line(fnd_file.output, errbuf);

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

2552: WHEN expect_http_ad THEN
2553: fnd_message.set_name('AR','HZ_MISSING_HTTP_SITE');
2554: fnd_msg_pub.add;
2555: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2556: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2557: fnd_global.local_chr(10);
2558: trace_handler(msg);
2559: END LOOP;
2560: fnd_message.clear;

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

2571: fnd_message.set_name('AR','HZ_PORT_NUMBER_EXPECTED');
2572: fnd_message.set_token('PORT', l_port);
2573: fnd_msg_pub.add;
2574: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2575: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2576: fnd_global.local_chr(10);
2577: trace_handler(msg);
2578: END LOOP;
2579: fnd_message.clear;

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

2589: WHEN nlsnumexp THEN
2590: fnd_message.set_name('AR','HZ_NUMERIC_CHAR_SET');
2591: fnd_msg_pub.add;
2592: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2593: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2594: fnd_global.local_chr(10);
2595: trace_handler(msg);
2596: END LOOP;
2597: fnd_message.clear;

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

2607: WHEN atleastonerow THEN
2608: fnd_message.set_name('AR','HZ_AT_LEAST_ONE_ROW');
2609: fnd_msg_pub.add;
2610: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2611: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2612: fnd_global.local_chr(10);
2613: trace_handler(msg);
2614: END LOOP;
2615: fnd_message.clear;

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

2626: fnd_message.set_name('AR','HZ_MAX_BATCH_SIZE_EXCEEDED');
2627: fnd_message.set_token('MAX', hz_geocode_pkg.g_max_rows);
2628: fnd_msg_pub.add;
2629: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2630: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2631: fnd_global.local_chr(10);
2632: trace_handler(msg);
2633: END LOOP;
2634: fnd_message.clear;

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

2642: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2643:
2644: WHEN exchttp THEN
2645: FOR j IN 1..fnd_msg_pub.count_msg LOOP
2646: msg := SUBSTRB(fnd_msg_pub.get(p_encoded => fnd_api.g_false),1,256) ||
2647: fnd_global.local_chr(10);
2648: trace_handler(msg);
2649: END LOOP;
2650: fnd_message.clear;