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_GNR_UTIL_PKG dependencies on FND_API

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172: l_msg_data VARCHAR2(1000);
173: l_return_status VARCHAR2(30);
174:
175: BEGIN
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:
178: -- get timezone id for changed location, if timezone_id is NULL
179: -- Same code as in HZ_LOCATION_V2PUB.UPDATE_LOCATION (to make it modular)
180: IF (p_new_location_rec.country IS NOT NULL AND

Line 181: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))

177:
178: -- get timezone id for changed location, if timezone_id is NULL
179: -- Same code as in HZ_LOCATION_V2PUB.UPDATE_LOCATION (to make it modular)
180: IF (p_new_location_rec.country IS NOT NULL AND
181: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
182: OR (p_new_location_rec.city IS NOT NULL AND
183: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
184: OR (p_new_location_rec.state IS NOT NULL AND
185: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char)<> UPPER(p_new_location_rec.state))

Line 183: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))

179: -- Same code as in HZ_LOCATION_V2PUB.UPDATE_LOCATION (to make it modular)
180: IF (p_new_location_rec.country IS NOT NULL AND
181: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
182: OR (p_new_location_rec.city IS NOT NULL AND
183: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
184: OR (p_new_location_rec.state IS NOT NULL AND
185: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char)<> UPPER(p_new_location_rec.state))
186: OR (p_new_location_rec.postal_code IS NOT NULL AND
187: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))

Line 185: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char)<> UPPER(p_new_location_rec.state))

181: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
182: OR (p_new_location_rec.city IS NOT NULL AND
183: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
184: OR (p_new_location_rec.state IS NOT NULL AND
185: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char)<> UPPER(p_new_location_rec.state))
186: OR (p_new_location_rec.postal_code IS NOT NULL AND
187: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))
188: THEN
189: l_changed_flag := 'Y';

Line 187: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))

183: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
184: OR (p_new_location_rec.state IS NOT NULL AND
185: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char)<> UPPER(p_new_location_rec.state))
186: OR (p_new_location_rec.postal_code IS NOT NULL AND
187: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))
188: THEN
189: l_changed_flag := 'Y';
190: END IF;
191:

Line 194: OR p_new_location_rec.timezone_id = fnd_api.g_miss_num)

190: END IF;
191:
192: IF ((l_changed_flag = 'Y') AND
193: (p_new_location_rec.timezone_id IS NULL
194: OR p_new_location_rec.timezone_id = fnd_api.g_miss_num)
195: )
196: THEN
197:
198: l_message_count := fnd_msg_pub.count_msg();

Line 201: p_init_msg_list => FND_API.G_FALSE,

197:
198: l_message_count := fnd_msg_pub.count_msg();
199: hz_timezone_pub.get_timezone_id(
200: p_api_version => 1.0,
201: p_init_msg_list => FND_API.G_FALSE,
202: p_postal_code => p_new_location_rec.postal_code,
203: p_city => p_new_location_rec.city,
204: p_state => p_new_location_rec.state,
205: p_country => p_new_location_rec.country,

Line 211: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

207: x_return_status => l_return_status ,
208: x_msg_count => l_msg_count ,
209: x_msg_data => l_msg_data);
210:
211: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
212: -- we don't raise error
213: p_new_location_rec.timezone_id := fnd_api.g_miss_num;
214: FOR i IN 1..(l_msg_count - l_message_count) LOOP
215: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);

Line 213: p_new_location_rec.timezone_id := fnd_api.g_miss_num;

209: x_msg_data => l_msg_data);
210:
211: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
212: -- we don't raise error
213: p_new_location_rec.timezone_id := fnd_api.g_miss_num;
214: FOR i IN 1..(l_msg_count - l_message_count) LOOP
215: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
216: END LOOP;
217: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 217: l_return_status := FND_API.G_RET_STS_SUCCESS;

213: p_new_location_rec.timezone_id := fnd_api.g_miss_num;
214: FOR i IN 1..(l_msg_count - l_message_count) LOOP
215: fnd_msg_pub.delete_msg(l_msg_count - l_message_count + 1 - i);
216: END LOOP;
217: l_return_status := FND_API.G_RET_STS_SUCCESS;
218: END IF;
219: END IF;
220:
221: -- call address key generation program

Line 312: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))

308: WHERE hps.location_id = p_new_location_rec.location_id
309: AND hps.identifying_address_flag = 'Y';
310: BEGIN
311: IF (p_new_location_rec.country IS NOT NULL AND
312: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
313: OR (p_new_location_rec.address1 IS NOT NULL AND
314: NVL(UPPER(p_old_location_rec.address1),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address1))
315: OR (p_new_location_rec.address2 IS NOT NULL AND
316: NVL(UPPER(p_old_location_rec.address2),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address2))

Line 314: NVL(UPPER(p_old_location_rec.address1),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address1))

310: BEGIN
311: IF (p_new_location_rec.country IS NOT NULL AND
312: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
313: OR (p_new_location_rec.address1 IS NOT NULL AND
314: NVL(UPPER(p_old_location_rec.address1),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address1))
315: OR (p_new_location_rec.address2 IS NOT NULL AND
316: NVL(UPPER(p_old_location_rec.address2),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address2))
317: OR (p_new_location_rec.address3 IS NOT NULL AND
318: NVL(UPPER(p_old_location_rec.address3),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address3))

Line 316: NVL(UPPER(p_old_location_rec.address2),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address2))

312: NVL(UPPER(p_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.country))
313: OR (p_new_location_rec.address1 IS NOT NULL AND
314: NVL(UPPER(p_old_location_rec.address1),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address1))
315: OR (p_new_location_rec.address2 IS NOT NULL AND
316: NVL(UPPER(p_old_location_rec.address2),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address2))
317: OR (p_new_location_rec.address3 IS NOT NULL AND
318: NVL(UPPER(p_old_location_rec.address3),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address3))
319: OR (p_new_location_rec.address4 IS NOT NULL AND
320: NVL(UPPER(p_old_location_rec.address4),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address4))

Line 318: NVL(UPPER(p_old_location_rec.address3),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address3))

314: NVL(UPPER(p_old_location_rec.address1),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address1))
315: OR (p_new_location_rec.address2 IS NOT NULL AND
316: NVL(UPPER(p_old_location_rec.address2),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address2))
317: OR (p_new_location_rec.address3 IS NOT NULL AND
318: NVL(UPPER(p_old_location_rec.address3),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address3))
319: OR (p_new_location_rec.address4 IS NOT NULL AND
320: NVL(UPPER(p_old_location_rec.address4),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address4))
321: OR (p_new_location_rec.city IS NOT NULL AND
322: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))

Line 320: NVL(UPPER(p_old_location_rec.address4),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address4))

316: NVL(UPPER(p_old_location_rec.address2),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address2))
317: OR (p_new_location_rec.address3 IS NOT NULL AND
318: NVL(UPPER(p_old_location_rec.address3),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address3))
319: OR (p_new_location_rec.address4 IS NOT NULL AND
320: NVL(UPPER(p_old_location_rec.address4),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address4))
321: OR (p_new_location_rec.city IS NOT NULL AND
322: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
323: OR (p_new_location_rec.postal_code IS NOT NULL AND
324: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))

Line 322: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))

318: NVL(UPPER(p_old_location_rec.address3),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address3))
319: OR (p_new_location_rec.address4 IS NOT NULL AND
320: NVL(UPPER(p_old_location_rec.address4),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address4))
321: OR (p_new_location_rec.city IS NOT NULL AND
322: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
323: OR (p_new_location_rec.postal_code IS NOT NULL AND
324: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))
325: OR (p_new_location_rec.state IS NOT NULL AND
326: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.state))

Line 324: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))

320: NVL(UPPER(p_old_location_rec.address4),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.address4))
321: OR (p_new_location_rec.city IS NOT NULL AND
322: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
323: OR (p_new_location_rec.postal_code IS NOT NULL AND
324: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))
325: OR (p_new_location_rec.state IS NOT NULL AND
326: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.state))
327: OR (p_new_location_rec.province IS NOT NULL AND
328: NVL(UPPER(p_old_location_rec.province),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.province))

Line 326: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.state))

322: NVL(UPPER(p_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.city))
323: OR (p_new_location_rec.postal_code IS NOT NULL AND
324: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))
325: OR (p_new_location_rec.state IS NOT NULL AND
326: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.state))
327: OR (p_new_location_rec.province IS NOT NULL AND
328: NVL(UPPER(p_old_location_rec.province),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.province))
329: OR (p_new_location_rec.county IS NOT NULL AND
330: NVL(UPPER(p_old_location_rec.county), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.county))

Line 328: NVL(UPPER(p_old_location_rec.province),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.province))

324: NVL(UPPER(p_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.postal_code))
325: OR (p_new_location_rec.state IS NOT NULL AND
326: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.state))
327: OR (p_new_location_rec.province IS NOT NULL AND
328: NVL(UPPER(p_old_location_rec.province),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.province))
329: OR (p_new_location_rec.county IS NOT NULL AND
330: NVL(UPPER(p_old_location_rec.county), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.county))
331: THEN
332: BEGIN

Line 330: NVL(UPPER(p_old_location_rec.county), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.county))

326: NVL(UPPER(p_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.state))
327: OR (p_new_location_rec.province IS NOT NULL AND
328: NVL(UPPER(p_old_location_rec.province),fnd_api.g_miss_char) <> UPPER(p_new_location_rec.province))
329: OR (p_new_location_rec.county IS NOT NULL AND
330: NVL(UPPER(p_old_location_rec.county), fnd_api.g_miss_char) <> UPPER(p_new_location_rec.county))
331: THEN
332: BEGIN
333: OPEN c1;
334: LOOP

Line 388: -- RAISE fnd_api.g_exc_error;

384: fnd_message.set_token('TABLE', 'HZ_PARTIES');
385: fnd_msg_pub.add;
386: */
387: CLOSE c1;
388: -- RAISE fnd_api.g_exc_error;
389: END;
390: END IF; -- location components have been modified
391: END;
392:

Line 456: x_status := fnd_api.g_ret_sts_success;

452:
453: BEGIN
454:
455: -- initializing the return status
456: x_status := fnd_api.g_ret_sts_success;
457:
458: -- delete thing the location id and table name combination from gnr
459:
460: DELETE FROM hz_geo_name_references

Line 466: x_status := fnd_api.g_ret_sts_unexp_error;

462: location_table_name = p_loctbl;
463: EXCEPTION
464: WHEN others THEN
465: --dbms_output.put_line('error in del gnr' ||sqlerrm);
466: x_status := fnd_api.g_ret_sts_unexp_error;
467: END delGNR;
468: --------------------------------------
469: -- procedures and functions
470: --------------------------------------

Line 511: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.

507: l_sql1 varchar2(1000);
508: l_eflag varchar2(2);
509:
510: BEGIN
511: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
512: /* flow:
513: 1. getcntrystyle()
514: 2. if both addrstyle and country are not null,
515: get mapId using both else use country

Line 520: IF (x_status <> fnd_api.g_ret_sts_success) THEN

516: */
517: --dbms_output.put_line('***bfr getcntrystyle');
518: hz_gnr_util_pkg.getcntrystyle(p_locid,p_loctbl,x_cntry,l_addrstyle,x_status);
519:
520: IF (x_status <> fnd_api.g_ret_sts_success) THEN
521: -- there is some error in getcntrystyle(), hence exit
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: --dbms_output.put_line('***after getcntrystyle');

Line 522: RAISE FND_API.G_EXC_ERROR;

518: hz_gnr_util_pkg.getcntrystyle(p_locid,p_loctbl,x_cntry,l_addrstyle,x_status);
519:
520: IF (x_status <> fnd_api.g_ret_sts_success) THEN
521: -- there is some error in getcntrystyle(), hence exit
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: --dbms_output.put_line('***after getcntrystyle');
525:
526: -- as getcntrystyle() validates the country - in this procedure

Line 556: x_status := fnd_api.G_RET_STS_ERROR;

552: WHEN no_data_found THEN
553:
554: IF (l_eflag IS NULL) THEN
555: -- no map details for given map record
556: x_status := fnd_api.G_RET_STS_ERROR;
557: --dbms_output.put_line('***bfr mesglog() in exception');
558: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_MAP_DTL', 'COUNTRY_CODE', x_cntry, NULL, NULL);
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF (l_eflag = 'AN') THEN

Line 559: RAISE FND_API.G_EXC_ERROR;

555: -- no map details for given map record
556: x_status := fnd_api.G_RET_STS_ERROR;
557: --dbms_output.put_line('***bfr mesglog() in exception');
558: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_MAP_DTL', 'COUNTRY_CODE', x_cntry, NULL, NULL);
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF (l_eflag = 'AN') THEN
561: -- address style case is null case
562: x_status := fnd_api.G_RET_STS_ERROR;
563: --dbms_output.put_line('***bfr mesglog() when address style is null');

Line 562: x_status := fnd_api.G_RET_STS_ERROR;

558: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_MAP_DTL', 'COUNTRY_CODE', x_cntry, NULL, NULL);
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF (l_eflag = 'AN') THEN
561: -- address style case is null case
562: x_status := fnd_api.G_RET_STS_ERROR;
563: --dbms_output.put_line('***bfr mesglog() when address style is null');
564: mesglog(p_locid,p_loctbl,'HZ_GEO_NOMAP', 'COUNTRY', x_cntry, NULL, NULL);
565: RAISE FND_API.G_EXC_ERROR;
566: ELSIF (l_eflag = 'A') THEN

Line 565: RAISE FND_API.G_EXC_ERROR;

561: -- address style case is null case
562: x_status := fnd_api.G_RET_STS_ERROR;
563: --dbms_output.put_line('***bfr mesglog() when address style is null');
564: mesglog(p_locid,p_loctbl,'HZ_GEO_NOMAP', 'COUNTRY', x_cntry, NULL, NULL);
565: RAISE FND_API.G_EXC_ERROR;
566: ELSIF (l_eflag = 'A') THEN
567: -- address style and country code combinatio does not exist
568: x_status := fnd_api.G_RET_STS_ERROR;
569: --dbms_output.put_line('***bfr mesglog() when address style is not null');

Line 568: x_status := fnd_api.G_RET_STS_ERROR;

564: mesglog(p_locid,p_loctbl,'HZ_GEO_NOMAP', 'COUNTRY', x_cntry, NULL, NULL);
565: RAISE FND_API.G_EXC_ERROR;
566: ELSIF (l_eflag = 'A') THEN
567: -- address style and country code combinatio does not exist
568: x_status := fnd_api.G_RET_STS_ERROR;
569: --dbms_output.put_line('***bfr mesglog() when address style is not null');
570: mesglog(p_locid,p_loctbl,'HZ_GEO_NOMAP_ASTYLE', 'COUNTRY', x_cntry, 'STYLE', l_addrstyle);
571: RAISE FND_API.G_EXC_ERROR;
572: ELSE

Line 571: RAISE FND_API.G_EXC_ERROR;

567: -- address style and country code combinatio does not exist
568: x_status := fnd_api.G_RET_STS_ERROR;
569: --dbms_output.put_line('***bfr mesglog() when address style is not null');
570: mesglog(p_locid,p_loctbl,'HZ_GEO_NOMAP_ASTYLE', 'COUNTRY', x_cntry, 'STYLE', l_addrstyle);
571: RAISE FND_API.G_EXC_ERROR;
572: ELSE
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575: END getMapId;

Line 573: RAISE FND_API.G_EXC_ERROR;

569: --dbms_output.put_line('***bfr mesglog() when address style is not null');
570: mesglog(p_locid,p_loctbl,'HZ_GEO_NOMAP_ASTYLE', 'COUNTRY', x_cntry, 'STYLE', l_addrstyle);
571: RAISE FND_API.G_EXC_ERROR;
572: ELSE
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575: END getMapId;
576:
577: -----------------------------------------

Line 639: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.

635: WHERE map_id = cp_map_id
636: ORDER BY loc_seq_num ASC;
637:
638: BEGIN
639: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
640: -- Check if API is called in debug mode. If yes, enable debug.
641: --enable_debug;
642:
643: /* flow:

Line 660: IF (x_status <> fnd_api.g_ret_sts_success) THEN

656:
657: hz_gnr_util_pkg.getMapId(p_locid, p_loctbl, x_cntry, x_mapId, x_status );
658:
659: -- given a mapid, get the details of the map
660: IF (x_status <> fnd_api.g_ret_sts_success) THEN
661: -- Debug info.
662: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'getMapId() failed',
664: p_prefix=>'ERROR',

Line 669: RAISE FND_API.G_EXC_ERROR;

665: p_msg_level=>fnd_log.level_error);
666: END IF;
667:
668: -- there is some error in getcntrystyle(), hence exit
669: RAISE FND_API.G_EXC_ERROR;
670: END IF;
671:
672: i := 1;
673: FOR c1rec IN c1(x_mapId)

Line 692: RAISE FND_API.G_EXC_ERROR;

688: p_prefix=>'ERROR',
689: p_msg_level=>fnd_log.level_error);
690: END IF;
691:
692: RAISE FND_API.G_EXC_ERROR;
693: END getmaprec;
694: -----------------------------------------
695: /**
696: * procedure getlocrec

Line 745: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.

741: l_len number;
742: l_debug_prefix VARCHAR2(30) := '';
743:
744: BEGIN
745: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
746:
747: l_sql_1 := 'select ';
748: FOR i IN x_mltbl.first..x_mltbl.last
749: LOOP

Line 818: x_status := fnd_api.G_RET_STS_ERROR;

814: x_mltbl(7).loc_compval,x_mltbl(8).loc_compval,x_mltbl(9).loc_compval
815: ,x_mltbl(10).loc_compval
816: USING IN p_locid;
817: ELSE
818: x_status := fnd_api.G_RET_STS_ERROR;
819: mesglog(p_locid,p_loctbl,'HZ_GEO_TOO_MANY_MAP_DTLS', NULL, NULL, NULL, NULL);
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822:

Line 820: RAISE FND_API.G_EXC_ERROR;

816: USING IN p_locid;
817: ELSE
818: x_status := fnd_api.G_RET_STS_ERROR;
819: mesglog(p_locid,p_loctbl,'HZ_GEO_TOO_MANY_MAP_DTLS', NULL, NULL, NULL, NULL);
820: RAISE FND_API.G_EXC_ERROR;
821: END IF;
822:
823: EXCEPTION
824: WHEN no_data_found THEN

Line 825: x_status := fnd_api.G_RET_STS_ERROR;

821: END IF;
822:
823: EXCEPTION
824: WHEN no_data_found THEN
825: x_status := fnd_api.G_RET_STS_ERROR;
826: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_LOC_REC', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
827: RAISE FND_API.G_EXC_ERROR;
828: END getlocrec;
829: -------------------------------------------

Line 827: RAISE FND_API.G_EXC_ERROR;

823: EXCEPTION
824: WHEN no_data_found THEN
825: x_status := fnd_api.G_RET_STS_ERROR;
826: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_LOC_REC', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
827: RAISE FND_API.G_EXC_ERROR;
828: END getlocrec;
829: -------------------------------------------
830: /**
831: * procedure getcntrystyle

Line 880: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.

876: l_len number;
877: l_debug_prefix VARCHAR2(30) := '';
878:
879: BEGIN
880: x_status := fnd_api.g_ret_sts_success; -- defaulting the sucess status.
881: -- Check if API is called in debug mode. If yes, enable debug.
882: --enable_debug;
883: -- three sql statements are necessary depending for three location tables.
884: -- the three tables are:

Line 919: x_status := fnd_api.G_RET_STS_ERROR;

915: END IF;
916: execute IMMEDIATE l_sql_3 INTO x_cntry, x_addrstyle USING IN p_locid;
917: ELSE
918: -- this means that the supplied table name is not supported by gnr in hz.k
919: x_status := fnd_api.G_RET_STS_ERROR;
920: -- Debug info.
921: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
922: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() when tbl name is invalid',
923: p_prefix=>'ERROR',

Line 927: RAISE FND_API.G_EXC_ERROR;

923: p_prefix=>'ERROR',
924: p_msg_level=>fnd_log.level_error);
925: END IF;
926: mesglog(p_locid,p_loctbl,'HZ_GEO_LOC_TABLE_INVALID', NULL, NULL, NULL, NULL);
927: RAISE FND_API.G_EXC_ERROR;
928: END IF;
929: IF (x_cntry IS NULL) THEN
930: -- Debug info.
931: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 936: x_status := fnd_api.G_RET_STS_ERROR;

932: hz_utility_v2pub.debug(p_message=>'country code is null',
933: p_prefix=>'ERROR',
934: p_msg_level=>fnd_log.level_error);
935: END IF;
936: x_status := fnd_api.G_RET_STS_ERROR;
937: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
938: RAISE FND_API.G_EXC_ERROR;
939: ELSE
940: l_len := LENGTHB(x_cntry);

Line 938: RAISE FND_API.G_EXC_ERROR;

934: p_msg_level=>fnd_log.level_error);
935: END IF;
936: x_status := fnd_api.G_RET_STS_ERROR;
937: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
938: RAISE FND_API.G_EXC_ERROR;
939: ELSE
940: l_len := LENGTHB(x_cntry);
941: IF l_len = 2 THEN
942: execute IMMEDIATE l_sql_4 INTO l_tmp USING IN x_cntry;

Line 944: x_status := fnd_api.G_RET_STS_ERROR;

940: l_len := LENGTHB(x_cntry);
941: IF l_len = 2 THEN
942: execute IMMEDIATE l_sql_4 INTO l_tmp USING IN x_cntry;
943: IF (l_tmp <> 1) THEN
944: x_status := fnd_api.G_RET_STS_ERROR;
945: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948: ELSE

Line 946: RAISE FND_API.G_EXC_ERROR;

942: execute IMMEDIATE l_sql_4 INTO l_tmp USING IN x_cntry;
943: IF (l_tmp <> 1) THEN
944: x_status := fnd_api.G_RET_STS_ERROR;
945: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948: ELSE
949: x_status := fnd_api.G_RET_STS_ERROR;
950: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);

Line 949: x_status := fnd_api.G_RET_STS_ERROR;

945: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948: ELSE
949: x_status := fnd_api.G_RET_STS_ERROR;
950: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: END IF;

Line 951: RAISE FND_API.G_EXC_ERROR;

947: END IF;
948: ELSE
949: x_status := fnd_api.G_RET_STS_ERROR;
950: mesglog(p_locid,p_loctbl,'HZ_GEO_INVALID_COUNTRY', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953: END IF;
954: --disable_debug;
955: EXCEPTION

Line 957: x_status := fnd_api.G_RET_STS_ERROR;

953: END IF;
954: --disable_debug;
955: EXCEPTION
956: WHEN no_data_found THEN
957: x_status := fnd_api.G_RET_STS_ERROR;
958: -- Debug info.
959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
960: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() in no data found',
961: p_prefix=>'ERROR',

Line 965: RAISE FND_API.G_EXC_ERROR;

961: p_prefix=>'ERROR',
962: p_msg_level=>fnd_log.level_error);
963: END IF;
964: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_LOC_REC', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);
965: RAISE FND_API.G_EXC_ERROR;
966:
967: END getcntrystyle;
968: ----------------------------------------------------
969:

Line 1044: x_status := fnd_api.g_ret_sts_success;

1040: l_program_application_id := hz_utility_v2pub.program_application_id;
1041: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1042:
1043: -- initializing the return status
1044: x_status := fnd_api.g_ret_sts_success;
1045:
1046: -- Check if API is called in debug mode. If yes, enable debug.
1047: --enable_debug;
1048:

Line 1070: IF x_status = FND_API.G_RET_STS_SUCCESS THEN

1066: p_prefix =>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_statement);
1068: END IF;
1069:
1070: IF x_status = FND_API.G_RET_STS_SUCCESS THEN
1071: FOR i IN p_maptbl.first .. p_maptbl.last
1072: LOOP
1073: IF (x_status = FND_API.G_RET_STS_SUCCESS) AND
1074: (p_maptbl(i).geography_id IS NOT NULL) THEN

Line 1073: IF (x_status = FND_API.G_RET_STS_SUCCESS) AND

1069:
1070: IF x_status = FND_API.G_RET_STS_SUCCESS THEN
1071: FOR i IN p_maptbl.first .. p_maptbl.last
1072: LOOP
1073: IF (x_status = FND_API.G_RET_STS_SUCCESS) AND
1074: (p_maptbl(i).geography_id IS NOT NULL) THEN
1075: BEGIN
1076: INSERT INTO hz_geo_name_references
1077: (location_id, geography_id, location_table_name,

Line 1114: x_status := fnd_api.g_ret_sts_unexp_error;

1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: END IF;
1113:
1114: x_status := fnd_api.g_ret_sts_unexp_error;
1115: END;
1116: END IF;
1117: END LOOP;
1118: ELSE

Line 1119: x_status := fnd_api.g_ret_sts_unexp_error;

1115: END;
1116: END IF;
1117: END LOOP;
1118: ELSE
1119: x_status := fnd_api.g_ret_sts_unexp_error;
1120: END IF;
1121: --disable_debug;
1122: EXCEPTION
1123: WHEN others THEN

Line 1137: x_status := fnd_api.g_ret_sts_unexp_error;

1133: p_prefix=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136:
1137: x_status := fnd_api.g_ret_sts_unexp_error;
1138: END gnrins;
1139: -----------------------------------------------------------
1140: /**
1141: * procedure gnrl

Line 1214: l_status := fnd_api.g_ret_sts_success;

1210: l_program_application_id := hz_utility_v2pub.program_application_id;
1211: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1212:
1213: -- initializing the return status
1214: l_status := fnd_api.g_ret_sts_success;
1215:
1216:
1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1239: RAISE FND_API.G_EXC_ERROR;

1235: p_prefix =>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_statement);
1237: END IF;
1238:
1239: RAISE FND_API.G_EXC_ERROR;
1240: -- x_status := fnd_api.g_ret_sts_unexp_error;
1241: END;
1242:
1243:

Line 1240: -- x_status := fnd_api.g_ret_sts_unexp_error;

1236: p_msg_level=>fnd_log.level_statement);
1237: END IF;
1238:
1239: RAISE FND_API.G_EXC_ERROR;
1240: -- x_status := fnd_api.g_ret_sts_unexp_error;
1241: END;
1242:
1243:
1244: -- This is to make the GNRL and GNR table in sync.

Line 1253: IF (p_mapStatus = FND_API.G_RET_STS_ERROR) THEN

1249: -- location id and table combination but still need to write the
1250: -- result of the latest run in GNRL table comment the following
1251: -- delete statement.
1252:
1253: IF (p_mapStatus = FND_API.G_RET_STS_ERROR) THEN
1254:
1255: -- Debug info.
1256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug(p_message=>'bfr delGNR()',

Line 1273: IF (l_status = fnd_api.g_ret_sts_success) THEN

1269: END IF;
1270:
1271: END IF;
1272:
1273: IF (l_status = fnd_api.g_ret_sts_success) THEN
1274: INSERT INTO hz_geo_name_reference_log
1275: (location_id, location_table_name,
1276: message_text,
1277: object_version_number, map_status,

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297: p_prefix=>'ERROR',
1298: p_msg_level=>fnd_log.level_error);
1299: END IF;
1300:
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303:
1304: --disable_debug;
1305: -- x_status := fnd_api.g_ret_sts_success;

Line 1305: -- x_status := fnd_api.g_ret_sts_success;

1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303:
1304: --disable_debug;
1305: -- x_status := fnd_api.g_ret_sts_success;
1306: EXCEPTION
1307: WHEN others THEN
1308:
1309: -- Debug info.

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: p_prefix=>'ERROR',
1318: p_msg_level=>fnd_log.level_error);
1319: END IF;
1320:
1321: RAISE FND_API.G_EXC_ERROR;
1322: -- x_status := fnd_api.g_ret_sts_unexp_error;
1323: END gnrl;
1324: ----------------------------------------------
1325: /**

Line 1322: -- x_status := fnd_api.g_ret_sts_unexp_error;

1318: p_msg_level=>fnd_log.level_error);
1319: END IF;
1320:
1321: RAISE FND_API.G_EXC_ERROR;
1322: -- x_status := fnd_api.g_ret_sts_unexp_error;
1323: END gnrl;
1324: ----------------------------------------------
1325: /**
1326: * Procedure to write a message to the out file

Line 1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1377: l_msg_data VARCHAR2(2000);
1378: BEGIN
1379: FND_MSG_PUB.Reset;
1380: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1381: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1382: END LOOP;
1383: -- FND_MSG_PUB.Delete_Msg;
1384: END logerr;
1385: ----------------------------------------------

Line 1397: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

1393: BEGIN
1394: FND_MSG_PUB.Reset;
1395:
1396: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1397: l_msg_data := l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1398: END LOOP;
1399: log(l_msg_data);
1400: RETURN l_msg_data;
1401: END logerror;

Line 1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Reset;
1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;

Line 1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

1428:
1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;
1435: ----------------------------------------------
1436: FUNCTION getQuery(

Line 1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));

1429: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1430: log(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1431: END LOOP;
1432: --hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,G_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1433: hz_gnr_util_pkg.gnrl(p_locid,p_loctbl,FND_API.G_RET_STS_ERROR,FND_MSG_PUB.Get(p_encoded => FND_API.G_TRUE));
1434: END mesglog;
1435: ----------------------------------------------
1436: FUNCTION getQuery(
1437: p_map_dtls_tbl IN maploc_rec_tbl_type,

Line 1454: x_status := FND_API.g_ret_sts_success;

1450: l_lowest_value_index number;
1451:
1452: BEGIN
1453:
1454: x_status := FND_API.g_ret_sts_success;
1455:
1456: IF P_MDU_TBL.COUNT = 1 THEN
1457: RETURN NULL;
1458: END IF;

Line 1557: x_status := FND_API.g_ret_sts_success;

1553: l_lowest_value_index number;
1554:
1555: BEGIN
1556:
1557: x_status := FND_API.g_ret_sts_success;
1558:
1559: IF P_MDU_TBL.COUNT = 1 THEN
1560: RETURN NULL;
1561: END IF;

Line 1699: RETURN FND_API.G_RET_STS_ERROR; -- Usage level validation has to go through.

1695: IF p_mdu_tbl.COUNT > 0 THEN
1696: i := p_mdu_tbl.FIRST;
1697: LOOP
1698: IF get_geo_id(p_mdu_tbl(i).GEOGRAPHY_TYPE,p_map_dtls_tbl) IS NULL THEN
1699: RETURN FND_API.G_RET_STS_ERROR; -- Usage level validation has to go through.
1700: END IF;
1701: EXIT WHEN i = p_mdu_tbl.LAST;
1702: i := p_mdu_tbl.NEXT(i);
1703: END LOOP;

Line 1705: RETURN FND_API.G_RET_STS_SUCCESS;

1701: EXIT WHEN i = p_mdu_tbl.LAST;
1702: i := p_mdu_tbl.NEXT(i);
1703: END LOOP;
1704: END IF;
1705: RETURN FND_API.G_RET_STS_SUCCESS;
1706: END get_usage_val_status;
1707: --------------------------------------
1708: -- The below finction is to get the address validation status
1709: -- depends on the map status and address validation level

Line 1741: l_addr_val_status := fnd_api.g_ret_sts_success;

1737: p_module => l_module
1738: );
1739: END IF;
1740:
1741: l_addr_val_status := fnd_api.g_ret_sts_success;
1742: l_missing_elements := NULL;
1743: -- If the map status = 'S' returm addr_val_status as 'S'
1744: IF x_map_status = 'S' then
1745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1806: l_addr_val_status := fnd_api.g_ret_sts_error;

1802: p_module_prefix => l_module_prefix,
1803: p_module => l_module
1804: );
1805: END IF;
1806: l_addr_val_status := fnd_api.g_ret_sts_error;
1807: IF p_mdu_tbl.COUNT > 0 THEN
1808: i := p_mdu_tbl.FIRST;
1809: LOOP
1810: IF p_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL THEN

Line 1811: l_addr_val_status := fnd_api.g_ret_sts_error;

1807: IF p_mdu_tbl.COUNT > 0 THEN
1808: i := p_mdu_tbl.FIRST;
1809: LOOP
1810: IF p_map_dtls_tbl(i).GEOGRAPHY_ID IS NULL THEN
1811: l_addr_val_status := fnd_api.g_ret_sts_error;
1812: IF l_missing_elements is NULL then
1813: l_missing_elements := p_map_dtls_tbl(i).GEOGRAPHY_TYPE;
1814: ELSE
1815: l_missing_elements := l_missing_elements ||', ' || p_map_dtls_tbl(i).GEOGRAPHY_TYPE;

Line 1849: x_status := fnd_api.g_ret_sts_success;

1845: p_module => l_module
1846: );
1847: END IF;
1848: l_addr_val_status := 'W';
1849: x_status := fnd_api.g_ret_sts_success;
1850: IF p_mdu_tbl.COUNT > 0 THEN
1851: i := p_mdu_tbl.FIRST;
1852: LOOP
1853: -- Remove the code the find out the missing elements in case of WARNING

Line 1856: -- l_addr_val_status := fnd_api.g_ret_sts_error;

1852: LOOP
1853: -- Remove the code the find out the missing elements in case of WARNING
1854: -- This is to allow null values for Warning address validation level. Bug # 5011366
1855: -- IF p_map_dtls_tbl(i).LOC_COMPVAL IS NULL THEN
1856: -- l_addr_val_status := fnd_api.g_ret_sts_error;
1857: -- IF l_missing_elements is NULL then
1858: -- l_missing_elements := p_map_dtls_tbl(i).GEOGRAPHY_TYPE;
1859: -- ELSE
1860: -- l_missing_elements := l_missing_elements ||', ' || p_map_dtls_tbl(i).GEOGRAPHY_TYPE;

Line 1878: x_status := fnd_api.g_ret_sts_success;

1874: -- IF l_missing_elements is NULL then
1875: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_WARN_ADDRESS');
1876: FND_MESSAGE.SET_TOKEN('P_ALL_ELEMENTS', l_invalid_elements);
1877: x_addr_warn_msg := FND_MESSAGE.get;
1878: x_status := fnd_api.g_ret_sts_success;
1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1880: hz_utility_v2pub.debug
1881: (p_message => 'These address elements are not validated : '||l_invalid_elements,
1882: p_prefix => l_debug_prefix,

Line 1925: l_addr_val_status := fnd_api.g_ret_sts_error;

1921: IF p_mdu_tbl.COUNT > 0 THEN
1922: i := p_mdu_tbl.FIRST;
1923: LOOP
1924: IF p_map_dtls_tbl(i).LOC_COMPVAL IS NULL THEN
1925: l_addr_val_status := fnd_api.g_ret_sts_error;
1926: IF l_missing_elements is NULL then
1927: l_missing_elements := p_map_dtls_tbl(i).GEOGRAPHY_TYPE;
1928: ELSE
1929: l_missing_elements := l_missing_elements ||', ' || p_map_dtls_tbl(i).GEOGRAPHY_TYPE;

Line 1937: x_status := fnd_api.g_ret_sts_success;

1933: i := p_mdu_tbl.NEXT(i);
1934: END LOOP;
1935:
1936: IF l_missing_elements is NULL then
1937: x_status := fnd_api.g_ret_sts_success;
1938: ELSE
1939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NULL_ADDRESS');
1940: FND_MESSAGE.SET_TOKEN('P_MISSING_ELEMENTS', l_missing_elements);
1941: FND_MSG_PUB.ADD;

Line 1976: x_status := FND_API.g_ret_sts_success;

1972: l_usage_value_count number;
1973: i number;
1974:
1975: BEGIN
1976: x_status := FND_API.g_ret_sts_success;
1977:
1978: IF p_map_dtls_tbl.COUNT = p_mdu_tbl.COUNT THEN
1979: -- Validation for the entire map is already performed. IF the counts are equal, the mapping for the usage is same
1980: -- as the total mapping. So no need to repeat the same validation.

Line 2243: IF p_lock_flag = 'T' OR p_lock_flag = FND_API.G_TRUE THEN

2239:
2240: -- If the Location updation is allowed
2241: IF location_updation_allowed(p_location_id) then
2242:
2243: IF p_lock_flag = 'T' OR p_lock_flag = FND_API.G_TRUE THEN
2244: -- get location components
2245: BEGIN
2246: SELECT COUNTRY, CITY, STATE, COUNTY, PROVINCE, POSTAL_CODE,POSTAL_PLUS4_CODE,
2247: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,

Line 2270: x_status := FND_API.G_RET_STS_ERROR;

2266: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2267: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2268: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2269: FND_MSG_PUB.ADD;
2270: x_status := FND_API.G_RET_STS_ERROR;
2271: END; -- end of SELECT
2272:
2273: ELSE -- do not lock the location record
2274: -- get location components

Line 2299: x_status := FND_API.G_RET_STS_ERROR;

2295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2296: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2297: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2298: FND_MSG_PUB.ADD;
2299: x_status := FND_API.G_RET_STS_ERROR;
2300: END; -- end of SELECT ;
2301: END IF;
2302:
2303: db_country := l_loc_components_rec.country;

Line 2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)

2324: -- Fix for Bug 5231893. Added UPPER to make case insensitive comaprison. It does not make sense to update
2325: -- location rec as part of GNR creation, just because fetched value from hz_locations is in different case
2326: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec
2327: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

Line 2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)

2325: -- location rec as part of GNR creation, just because fetched value from hz_locations is in different case
2326: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec
2327: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)

Line 2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)

2326: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec
2327: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)

Line 2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)

2327: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)

Line 2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

2328: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)

Line 2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)

2329: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)

Line 2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)

2330: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)

Line 2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)

2331: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)

Line 2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)

2332: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)

Line 2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)

2333: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)

Line 2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)

2334: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)

Line 2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)

2335: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)

Line 2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)

2336: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2344: THEN

Line 2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)

2337: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2344: THEN
2345: NULL;

Line 2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)

2338: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2344: THEN
2345: NULL;
2346: ELSE

Line 2343: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)

2339: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2344: THEN
2345: NULL;
2346: ELSE
2347:

Line 2402: NVL(UPPER(l_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.country))

2398: l_new_location_rec.address3 := l_address3;
2399: l_new_location_rec.address4 := l_address4;
2400: l_new_location_rec.address_key := l_address_key;
2401: IF (l_new_location_rec.country IS NOT NULL AND
2402: NVL(UPPER(l_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.country))
2403: OR
2404: (l_new_location_rec.city IS NOT NULL AND
2405: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))
2406: OR

Line 2405: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))

2401: IF (l_new_location_rec.country IS NOT NULL AND
2402: NVL(UPPER(l_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.country))
2403: OR
2404: (l_new_location_rec.city IS NOT NULL AND
2405: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))
2406: OR
2407: (l_new_location_rec.state IS NOT NULL AND
2408: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))
2409: OR

Line 2408: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))

2404: (l_new_location_rec.city IS NOT NULL AND
2405: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))
2406: OR
2407: (l_new_location_rec.state IS NOT NULL AND
2408: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))
2409: OR
2410: (l_new_location_rec.postal_code IS NOT NULL AND
2411: NVL(UPPER(l_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.postal_code))
2412: THEN

Line 2411: NVL(UPPER(l_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.postal_code))

2407: (l_new_location_rec.state IS NOT NULL AND
2408: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))
2409: OR
2410: (l_new_location_rec.postal_code IS NOT NULL AND
2411: NVL(UPPER(l_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.postal_code))
2412: THEN
2413: l_new_location_rec.timezone_id := NULL;
2414: ELSE
2415: l_new_location_rec.timezone_id := l_time_zone_id;

Line 2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)

2452: -- fix for bug # 4169728. Set address_text to null in hz_cust_acct_sites_all table if,
2453: -- city, state, province or postal_code changes in hz_location table.
2454: -- address_text column in hz_cust_acct_sites_all is populated by the concurrent program,
2455: -- "Customer text data creation and indexing", if address_text is null.
2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2457: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2458: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2459: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2460: THEN

Line 2457: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)

2453: -- city, state, province or postal_code changes in hz_location table.
2454: -- address_text column in hz_cust_acct_sites_all is populated by the concurrent program,
2455: -- "Customer text data creation and indexing", if address_text is null.
2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2457: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2458: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2459: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2460: THEN
2461: NULL;

Line 2458: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

2454: -- address_text column in hz_cust_acct_sites_all is populated by the concurrent program,
2455: -- "Customer text data creation and indexing", if address_text is null.
2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2457: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2458: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2459: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2460: THEN
2461: NULL;
2462: ELSE

Line 2459: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)

2455: -- "Customer text data creation and indexing", if address_text is null.
2456: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2457: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2458: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2459: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2460: THEN
2461: NULL;
2462: ELSE
2463: UPDATE hz_cust_acct_sites_all cas

Line 2473: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)

2469: WHERE ps.location_id = p_location_id
2470: AND cas.party_site_id = ps.party_site_id );
2471: END IF;
2472:
2473: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

Line 2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)

2470: AND cas.party_site_id = ps.party_site_id );
2471: END IF;
2472:
2473: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2478: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)

Line 2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)

2471: END IF;
2472:
2473: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2478: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2479: THEN

Line 2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)

2472:
2473: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2478: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2479: THEN
2480: NULL;

Line 2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

2473: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2478: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2479: THEN
2480: NULL;
2481: ELSE

Line 2478: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)

2474: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2475: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2476: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2477: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2478: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2479: THEN
2480: NULL;
2481: ELSE
2482: l_location_profile_rec.location_profile_id := NULL;

Line 2505: l_return_status := FND_API.G_RET_STS_SUCCESS;

2501: ELSE
2502: l_location_profile_rec.prov_state_admin_code := NULL;
2503: END IF;
2504:
2505: l_return_status := FND_API.G_RET_STS_SUCCESS;
2506:
2507: hz_location_profile_pvt.update_location_profile (
2508: p_location_profile_rec => l_location_profile_rec
2509: ,x_return_status => l_return_status

Line 2513: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN

2509: ,x_return_status => l_return_status
2510: ,x_msg_count => l_msg_count
2511: ,x_msg_data => l_msg_data );
2512:
2513: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2514: RAISE fnd_api.g_exc_error;
2515: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2516: RAISE fnd_api.g_exc_unexpected_error;
2517: END IF;

Line 2514: RAISE fnd_api.g_exc_error;

2510: ,x_msg_count => l_msg_count
2511: ,x_msg_data => l_msg_data );
2512:
2513: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2514: RAISE fnd_api.g_exc_error;
2515: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2516: RAISE fnd_api.g_exc_unexpected_error;
2517: END IF;
2518: END IF;

Line 2515: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2511: ,x_msg_data => l_msg_data );
2512:
2513: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2514: RAISE fnd_api.g_exc_error;
2515: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2516: RAISE fnd_api.g_exc_unexpected_error;
2517: END IF;
2518: END IF;
2519:

Line 2516: RAISE fnd_api.g_exc_unexpected_error;

2512:
2513: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2514: RAISE fnd_api.g_exc_error;
2515: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2516: RAISE fnd_api.g_exc_unexpected_error;
2517: END IF;
2518: END IF;
2519:
2520: -- Call post_location_update to do post update process.

Line 2625: IF NVL(UPPER(p_map_dtls_tbl(i).LOC_COMPVAL),FND_API.G_MISS_CHAR) <>

2621: LOOP
2622: IF p_map_dtls_tbl(i).GEOGRAPHY_ID = l_map_dtls_tbl(j).GEOGRAPHY_ID THEN
2623: -- Fix for Bug 5231893 (added UPPER to do case insensitive comaprison
2624: -- Added on 18-May-2006 Nishant)
2625: IF NVL(UPPER(p_map_dtls_tbl(i).LOC_COMPVAL),FND_API.G_MISS_CHAR) <>
2626: NVL(UPPER(l_map_dtls_tbl(j).LOC_COMPVAL),FND_API.G_MISS_CHAR) THEN
2627: l_return := 'Y';
2628: END IF;
2629: END IF;

Line 2626: NVL(UPPER(l_map_dtls_tbl(j).LOC_COMPVAL),FND_API.G_MISS_CHAR) THEN

2622: IF p_map_dtls_tbl(i).GEOGRAPHY_ID = l_map_dtls_tbl(j).GEOGRAPHY_ID THEN
2623: -- Fix for Bug 5231893 (added UPPER to do case insensitive comaprison
2624: -- Added on 18-May-2006 Nishant)
2625: IF NVL(UPPER(p_map_dtls_tbl(i).LOC_COMPVAL),FND_API.G_MISS_CHAR) <>
2626: NVL(UPPER(l_map_dtls_tbl(j).LOC_COMPVAL),FND_API.G_MISS_CHAR) THEN
2627: l_return := 'Y';
2628: END IF;
2629: END IF;
2630: EXIT WHEN j = l_map_dtls_tbl.LAST;

Line 2727: x_status := FND_API.g_ret_sts_success;

2723: l_program_application_id := hz_utility_v2pub.program_application_id;
2724: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
2725: l_api_purpose := HZ_GNR_PKG.G_API_PURPOSE;
2726:
2727: x_status := FND_API.g_ret_sts_success;
2728:
2729: -- retain_gnr_yn will tell whether we have retain old GNR records or not.
2730: -- If l_retain_flag = 'Y' then exit without ceate/update of GNR and hz_location
2731:

Line 2995: x_status := fnd_api.g_ret_sts_unexp_error;

2991:
2992: END IF; -- END of retain_gnr check
2993:
2994: EXCEPTION WHEN OTHERS THEN
2995: x_status := fnd_api.g_ret_sts_unexp_error;
2996: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2997: hz_utility_v2pub.debug
2998: (p_message => 'EXCEPTION during create_gnr for '||
2999: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||

Line 3060: x_status := FND_API.g_ret_sts_success;

3056: l_conc_login_id := fnd_global.conc_login_id;
3057: l_program_application_id := hz_utility_v2pub.program_application_id;
3058: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
3059:
3060: x_status := FND_API.g_ret_sts_success;
3061:
3062: l_success := 'N';
3063: l_usage_log_exists := 'N';
3064: FOR l_c_gnr_log IN c_gnr_log LOOP

Line 3128: x_status := fnd_api.g_ret_sts_unexp_error;

3124: END IF;
3125:
3126: RETURN FALSE;
3127: EXCEPTION WHEN OTHERS THEN
3128: x_status := fnd_api.g_ret_sts_unexp_error;
3129: RETURN FALSE;
3130: END check_GNR_For_Usage;
3131: --------------------------------------
3132: --------------------------------------

Line 3212: x_status := FND_API.g_ret_sts_success;

3208: l_child_geography_type varchar2(30);
3209: l_country_geo_type varchar2(30);
3210:
3211: BEGIN
3212: x_status := FND_API.g_ret_sts_success;
3213:
3214: --hk_debugl('Iteration : '||to_char(p_iteration));
3215: l_country_geo_type := 'COUNTRY';
3216:

Line 3334: x_status := FND_API.g_ret_sts_success;

3330: END IF;
3331:
3332: END prcess_no_match;
3333: BEGIN
3334: x_status := FND_API.g_ret_sts_success;
3335: IF x_map_dtls_tbl.COUNT > 0 THEN
3336: reverse_tbl(x_map_dtls_tbl,l_map_dtls_tbl);
3337: END IF;
3338:

Line 3358: x_status := FND_API.g_ret_sts_error;

3354: IF p_mdu_tbl.COUNT > 0 THEN
3355: i := p_mdu_tbl.FIRST;
3356: LOOP
3357: If p_mdu_tbl(i).LOC_COMPVAL IS NULL THEN
3358: x_status := FND_API.g_ret_sts_error;
3359: RETURN;
3360: END IF;
3361: EXIT WHEN i = p_mdu_tbl.LAST;
3362: i := p_mdu_tbl.NEXT(i);

Line 3364: x_status := FND_API.g_ret_sts_success;

3360: END IF;
3361: EXIT WHEN i = p_mdu_tbl.LAST;
3362: i := p_mdu_tbl.NEXT(i);
3363: END LOOP;
3364: x_status := FND_API.g_ret_sts_success;
3365:
3366: END IF;
3367: END getMinValStatus;
3368: --------------------------------------

Line 3462: x_status := FND_API.g_ret_sts_success;

3458: END;
3459:
3460: BEGIN
3461:
3462: x_status := FND_API.g_ret_sts_success;
3463: l_name_value(2).name := 'ADDRESS_STYLE';
3464: l_name_value(2).value := p_loc_components_rec.ADDRESS_STYLE;
3465: l_name_value(3).name := 'COUNTRY';
3466: l_name_value(3).value := p_loc_components_rec.COUNTRY;