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 558: fnd_msg_pub.initialize;

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,
562: fnd_message.get_string('FND',

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

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;
1412: -- J. del Callar: Re-initialize the stack for the next set.

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 1413: fnd_msg_pub.initialize;

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;
1414: status_handler(l_return_status, x_return_status);
1415: END IF;
1416:
1417: FOR j IN 1..l_array.COUNT LOOP

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

1601: END IF;
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;

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 1641: fnd_msg_pub.add;

1637:
1638: EXCEPTION
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);

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

1638: EXCEPTION
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;

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 1660: fnd_msg_pub.add;

1656:
1657: WHEN port_number THEN
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);

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

1657: WHEN port_number THEN
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;

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 1678: fnd_msg_pub.add;

1674: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1675:
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);

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

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

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 1696: fnd_msg_pub.add;

1692: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
1693:
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);

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

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

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 1715: fnd_msg_pub.add;

1711:
1712: WHEN morethanmaxrow THEN
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);

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

1712: WHEN morethanmaxrow THEN
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;

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 1732: FOR j IN 1..fnd_msg_pub.count_msg LOOP

1728: retcode := '2';
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;

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 1921: -- fnd_msg_pub

1917: -- Oracle's eLocation service.
1918: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1919: -- hz_utility_v2pub
1920: -- fnd_message
1921: -- fnd_msg_pub
1922: -- MODIFICATION HISTORY
1923: -- 29-11-2010 Sudhir Gokavarapu Created - ER10211310
1924: -- Bug12386319 default value of p_nb_row is changed to 10.
1925: -- Bug12386226 - When Match Count is zero then

Line 2035: fnd_msg_pub.initialize;

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,
2039: fnd_message.get_string('FND',

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

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;
2352: -- J. del Callar: Re-initialize the stack for the next set.

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 2353: fnd_msg_pub.initialize;

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;
2354: status_handler(l_return_status, x_return_status);
2355: END IF;
2356:
2357: FOR j IN 1..l_array.COUNT LOOP

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

2510: );
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;

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 2554: fnd_msg_pub.add;

2550:
2551: EXCEPTION
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);

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

2551: EXCEPTION
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;

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 2573: fnd_msg_pub.add;

2569:
2570: WHEN port_number THEN
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);

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

2570: WHEN port_number THEN
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;

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 2591: fnd_msg_pub.add;

2587: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2588:
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);

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

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

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 2609: fnd_msg_pub.add;

2605: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');
2606:
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);

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

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

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 2628: fnd_msg_pub.add;

2624:
2625: WHEN morethanmaxrow THEN
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);

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

2625: WHEN morethanmaxrow THEN
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;

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 2645: FOR j IN 1..fnd_msg_pub.count_msg LOOP

2641: retcode := '2';
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;

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;

Line 2687: -- fnd_msg_pub

2683: -- that queries can accurately extract the spatial data.
2684: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
2685: -- hz_utility_v2pub
2686: -- fnd_message
2687: -- fnd_msg_pub
2688: -- ARGUMENTS
2689: -- IN:
2690: -- p_concurrent_mode Set to 'Y' if the rebuild is running
2691: -- as its own concurrent program. Set to

Line 2855: fnd_msg_pub.add;

2851: fnd_message.get_string('FND', 'CONC-CP SUCCESSFUL TERMINATION'));
2852: ELSE
2853: -- otherwise, just push the error onto the stack.
2854: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');
2855: fnd_msg_pub.add;
2856: END IF;
2857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2858: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
2859: p_prefix=>l_debug_prefix,

Line 2886: fnd_msg_pub.add;

2882: fnd_file.put_line(fnd_file.output,
2883: fnd_message.get_string('FND',
2884: 'CONC-CHECK LOG FOR DETAILS'));
2885: ELSE
2886: fnd_msg_pub.add;
2887: END IF;
2888: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2889: hz_utility_v2pub.debug(p_message=>g_pkg_name||' Error:',
2890: p_prefix=>'SQL ERROR',