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 2248: IF p_lock_flag = 'T' OR p_lock_flag = FND_API.G_TRUE THEN

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

Line 2275: x_status := FND_API.G_RET_STS_ERROR;

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

Line 2304: x_status := FND_API.G_RET_STS_ERROR;

2300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2301: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
2302: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
2303: FND_MSG_PUB.ADD;
2304: x_status := FND_API.G_RET_STS_ERROR;
2305: END; -- end of SELECT ;
2306: END IF;
2307:
2308: db_country := l_loc_components_rec.country;

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

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

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

2330: -- location rec as part of GNR creation, just because fetched value from hz_locations is in different case
2331: -- than that derived from HZ_GEOGRAPHIES. It also improves performance by not updating that location rec
2332: -- and doing subsequent processes related to update_location. (18-MAY-2006 Nishant)
2333: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2338: 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 2335: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)

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

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

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

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

2333: IF NVL(UPPER(db_country),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2334: AND NVL(UPPER(db_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)

Line 2338: 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_city),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2335: AND NVL(UPPER(db_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)

Line 2339: 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_state),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2336: AND NVL(UPPER(db_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)

Line 2340: 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_county),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2337: AND NVL(UPPER(db_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)

Line 2341: 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_province),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2338: AND NVL(UPPER(db_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)

Line 2342: 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_postal_code),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2339: AND NVL(UPPER(db_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)

Line 2343: 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_attribute1),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute1),fnd_api.g_miss_char)
2340: AND NVL(UPPER(db_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2347: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)

Line 2344: 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_attribute2),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute2),fnd_api.g_miss_char)
2341: AND NVL(UPPER(db_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2347: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2348: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)

Line 2345: 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_attribute3),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute3),fnd_api.g_miss_char)
2342: AND NVL(UPPER(db_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2347: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2348: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2349: THEN

Line 2346: 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_attribute4),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute4),fnd_api.g_miss_char)
2343: AND NVL(UPPER(db_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2347: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2348: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2349: THEN
2350: NULL;

Line 2347: 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_attribute5),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute5),fnd_api.g_miss_char)
2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2347: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2348: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2349: THEN
2350: NULL;
2351: ELSE

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

2344: AND NVL(UPPER(db_attribute6),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute6),fnd_api.g_miss_char)
2345: AND NVL(UPPER(db_attribute7),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute7),fnd_api.g_miss_char)
2346: AND NVL(UPPER(db_attribute8),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute8),fnd_api.g_miss_char)
2347: AND NVL(UPPER(db_attribute9),fnd_api.g_miss_char) = NVL(UPPER(l_loc_components_rec.attribute9),fnd_api.g_miss_char)
2348: AND NVL(UPPER(db_attribute10),fnd_api.g_miss_char)= NVL(UPPER(l_loc_components_rec.attribute10),fnd_api.g_miss_char)
2349: THEN
2350: NULL;
2351: ELSE
2352:

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

2403: l_new_location_rec.address3 := l_address3;
2404: l_new_location_rec.address4 := l_address4;
2405: l_new_location_rec.address_key := l_address_key;
2406: IF (l_new_location_rec.country IS NOT NULL AND
2407: NVL(UPPER(l_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.country))
2408: OR
2409: (l_new_location_rec.city IS NOT NULL AND
2410: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))
2411: OR

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

2406: IF (l_new_location_rec.country IS NOT NULL AND
2407: NVL(UPPER(l_old_location_rec.country), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.country))
2408: OR
2409: (l_new_location_rec.city IS NOT NULL AND
2410: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))
2411: OR
2412: (l_new_location_rec.state IS NOT NULL AND
2413: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))
2414: OR

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

2409: (l_new_location_rec.city IS NOT NULL AND
2410: NVL(UPPER(l_old_location_rec.city), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.city))
2411: OR
2412: (l_new_location_rec.state IS NOT NULL AND
2413: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))
2414: OR
2415: (l_new_location_rec.postal_code IS NOT NULL AND
2416: NVL(UPPER(l_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.postal_code))
2417: THEN

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

2412: (l_new_location_rec.state IS NOT NULL AND
2413: NVL(UPPER(l_old_location_rec.state), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.state))
2414: OR
2415: (l_new_location_rec.postal_code IS NOT NULL AND
2416: NVL(UPPER(l_old_location_rec.postal_code), fnd_api.g_miss_char) <> UPPER(l_new_location_rec.postal_code))
2417: THEN
2418: l_new_location_rec.timezone_id := NULL;
2419: ELSE
2420: l_new_location_rec.timezone_id := l_time_zone_id;

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

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

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

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

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

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

Line 2464: 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: -- "Customer text data creation and indexing", if address_text is null.
2461: IF nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2462: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2463: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2464: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2465: THEN
2466: NULL;
2467: ELSE
2468: UPDATE hz_cust_acct_sites_all cas

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

2474: WHERE ps.location_id = p_location_id
2475: AND cas.party_site_id = ps.party_site_id );
2476: END IF;
2477:
2478: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2479: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2481: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2482: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)

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

2475: AND cas.party_site_id = ps.party_site_id );
2476: END IF;
2477:
2478: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2479: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2481: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2482: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2483: 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 2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)

2476: END IF;
2477:
2478: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2479: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2481: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2482: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2483: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2484: THEN

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

2477:
2478: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2479: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2481: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2482: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2483: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2484: THEN
2485: NULL;

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

2478: IF nvl(UPPER(db_country),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.country),fnd_api.g_miss_char)
2479: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2481: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2482: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2483: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2484: THEN
2485: NULL;
2486: ELSE

Line 2483: 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: AND nvl(UPPER(db_city),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.city),fnd_api.g_miss_char)
2480: AND nvl(UPPER(db_state),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.state),fnd_api.g_miss_char)
2481: AND nvl(UPPER(db_county),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.county),fnd_api.g_miss_char)
2482: AND nvl(UPPER(db_province),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.province),fnd_api.g_miss_char)
2483: AND nvl(UPPER(db_postal_code),fnd_api.g_miss_char) = nvl(UPPER(l_loc_components_rec.postal_code),fnd_api.g_miss_char)
2484: THEN
2485: NULL;
2486: ELSE
2487: l_location_profile_rec.location_profile_id := NULL;

Line 2510: l_return_status := FND_API.G_RET_STS_SUCCESS;

2506: ELSE
2507: l_location_profile_rec.prov_state_admin_code := NULL;
2508: END IF;
2509:
2510: l_return_status := FND_API.G_RET_STS_SUCCESS;
2511:
2512: hz_location_profile_pvt.update_location_profile (
2513: p_location_profile_rec => l_location_profile_rec
2514: ,x_return_status => l_return_status

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

2514: ,x_return_status => l_return_status
2515: ,x_msg_count => l_msg_count
2516: ,x_msg_data => l_msg_data );
2517:
2518: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2519: RAISE fnd_api.g_exc_error;
2520: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE fnd_api.g_exc_unexpected_error;
2522: END IF;

Line 2519: RAISE fnd_api.g_exc_error;

2515: ,x_msg_count => l_msg_count
2516: ,x_msg_data => l_msg_data );
2517:
2518: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2519: RAISE fnd_api.g_exc_error;
2520: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE fnd_api.g_exc_unexpected_error;
2522: END IF;
2523: END IF;

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

2516: ,x_msg_data => l_msg_data );
2517:
2518: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2519: RAISE fnd_api.g_exc_error;
2520: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE fnd_api.g_exc_unexpected_error;
2522: END IF;
2523: END IF;
2524:

Line 2521: RAISE fnd_api.g_exc_unexpected_error;

2517:
2518: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
2519: RAISE fnd_api.g_exc_error;
2520: ELSIF(l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE fnd_api.g_exc_unexpected_error;
2522: END IF;
2523: END IF;
2524:
2525: -- Call post_location_update to do post update process.

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

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

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

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

Line 2732: x_status := FND_API.g_ret_sts_success;

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

Line 3000: x_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3065: x_status := FND_API.g_ret_sts_success;

3061: l_conc_login_id := fnd_global.conc_login_id;
3062: l_program_application_id := hz_utility_v2pub.program_application_id;
3063: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
3064:
3065: x_status := FND_API.g_ret_sts_success;
3066:
3067: l_success := 'N';
3068: l_usage_log_exists := 'N';
3069: FOR l_c_gnr_log IN c_gnr_log LOOP

Line 3133: x_status := fnd_api.g_ret_sts_unexp_error;

3129: END IF;
3130:
3131: RETURN FALSE;
3132: EXCEPTION WHEN OTHERS THEN
3133: x_status := fnd_api.g_ret_sts_unexp_error;
3134: RETURN FALSE;
3135: END check_GNR_For_Usage;
3136: --------------------------------------
3137: --------------------------------------

Line 3217: x_status := FND_API.g_ret_sts_success;

3213: l_child_geography_type varchar2(30);
3214: l_country_geo_type varchar2(30);
3215:
3216: BEGIN
3217: x_status := FND_API.g_ret_sts_success;
3218:
3219: --hk_debugl('Iteration : '||to_char(p_iteration));
3220: l_country_geo_type := 'COUNTRY';
3221:

Line 3339: x_status := FND_API.g_ret_sts_success;

3335: END IF;
3336:
3337: END prcess_no_match;
3338: BEGIN
3339: x_status := FND_API.g_ret_sts_success;
3340: IF x_map_dtls_tbl.COUNT > 0 THEN
3341: reverse_tbl(x_map_dtls_tbl,l_map_dtls_tbl);
3342: END IF;
3343:

Line 3363: x_status := FND_API.g_ret_sts_error;

3359: IF p_mdu_tbl.COUNT > 0 THEN
3360: i := p_mdu_tbl.FIRST;
3361: LOOP
3362: If p_mdu_tbl(i).LOC_COMPVAL IS NULL THEN
3363: x_status := FND_API.g_ret_sts_error;
3364: RETURN;
3365: END IF;
3366: EXIT WHEN i = p_mdu_tbl.LAST;
3367: i := p_mdu_tbl.NEXT(i);

Line 3369: x_status := FND_API.g_ret_sts_success;

3365: END IF;
3366: EXIT WHEN i = p_mdu_tbl.LAST;
3367: i := p_mdu_tbl.NEXT(i);
3368: END LOOP;
3369: x_status := FND_API.g_ret_sts_success;
3370:
3371: END IF;
3372: END getMinValStatus;
3373: --------------------------------------

Line 3467: x_status := FND_API.g_ret_sts_success;

3463: END;
3464:
3465: BEGIN
3466:
3467: x_status := FND_API.g_ret_sts_success;
3468: l_name_value(2).name := 'ADDRESS_STYLE';
3469: l_name_value(2).value := p_loc_components_rec.ADDRESS_STYLE;
3470: l_name_value(3).name := 'COUNTRY';
3471: l_name_value(3).value := p_loc_components_rec.COUNTRY;