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

Line 81: x_ret_status := FND_API.G_RET_STS_ERROR;

77: AND descriptive_flexfield_name = l_descriptive_flexfield_name
78: AND descriptive_flex_context_code = p_context;
79:
80: EXCEPTION WHEN NO_DATA_FOUND THEN
81: x_ret_status := FND_API.G_RET_STS_ERROR;
82: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ADDRESS_STYLE_INVALID');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: END;

Line 84: RAISE FND_API.G_EXC_ERROR;

80: EXCEPTION WHEN NO_DATA_FOUND THEN
81: x_ret_status := FND_API.G_RET_STS_ERROR;
82: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ADDRESS_STYLE_INVALID');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_ERROR;
85: END;
86: END;
87:
88: END validate_address_context;

Line 98: x_ret_status := FND_API.G_RET_STS_SUCCESS;

94: l_exists VARCHAR2(6);
95: l_application_id NUMBER;
96: BEGIN
97:
98: x_ret_status := FND_API.G_RET_STS_SUCCESS;
99:
100: IF UPPER(p_location_table_name) = 'HR_LOCATIONS_ALL' THEN
101: l_application_id := 800;
102: ELSIF UPPER(p_location_table_name) = 'HZ_LOCATIONS' THEN

Line 118: x_ret_status := FND_API.G_RET_STS_ERROR;

114: AND col.column_name NOT IN ('LAST_UPDATED_BY', 'CREATION_DATE', 'CREATED_BY',
115: 'LAST_UPDATE_DATE', 'LAST_UPDATE_LOGIN');
116:
117: EXCEPTION WHEN NO_DATA_FOUND THEN
118: x_ret_status := FND_API.G_RET_STS_ERROR;
119: x_error_code := 'HZ_GEO_LOC_COMP_INVALID';
120:
121: END;
122:

Line 129: x_ret_status := FND_API.G_RET_STS_SUCCESS;

125: x_error_code OUT NOCOPY VARCHAR2) IS
126: l_exists VARCHAR2(6);
127: BEGIN
128:
129: x_ret_status := FND_API.G_RET_STS_SUCCESS;
130:
131: SELECT 'Exists'
132: INTO l_exists
133: FROM hz_geography_types_b

Line 137: x_ret_status := FND_API.G_RET_STS_ERROR;

133: FROM hz_geography_types_b
134: WHERE geography_type = UPPER(p_geo_type);
135:
136: EXCEPTION WHEN NO_DATA_FOUND THEN
137: x_ret_status := FND_API.G_RET_STS_ERROR;
138: x_error_code := 'HZ_GEO_GEO_TYPE_INVALID';
139:
140: END;
141:

Line 161: x_ret_status := FND_API.G_RET_STS_SUCCESS;

157: l_geo_element_col hz_geo_structure_levels.geography_element_column%TYPE;
158:
159: BEGIN
160:
161: x_ret_status := FND_API.G_RET_STS_SUCCESS;
162:
163: BEGIN
164: SELECT geography_element_column
165: INTO p_geo_element_col

Line 187: x_ret_status := FND_API.G_RET_STS_ERROR;

183: END IF;
184: END LOOP;
185: CLOSE determine_geo_element_col;
186: IF p_geo_element_col IS NULL THEN
187: x_ret_status := FND_API.G_RET_STS_ERROR;
188: END IF;
189: END IF;
190:
191: END find_geo_element_col;

Line 228: x_return_status := FND_API.G_RET_STS_SUCCESS;

224: AND country_code = c_country;
225:
226: BEGIN
227:
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229: l_error_code := NULL;
230:
231: -- Location table name is mandatory
232:

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230:
231: -- Location table name is mandatory
232:
233: IF p_geo_struct_map_rec.loc_tbl_name IS NULL THEN
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
236: FND_MSG_PUB.ADD;
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;

Line 237: RAISE FND_API.G_EXC_ERROR;

233: IF p_geo_struct_map_rec.loc_tbl_name IS NULL THEN
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
236: FND_MSG_PUB.ADD;
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: -- Country code is mandatory
241:

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239:
240: -- Country code is mandatory
241:
242: IF p_geo_struct_map_rec.country_code IS NULL THEN
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;

Line 246: RAISE FND_API.G_EXC_ERROR;

242: IF p_geo_struct_map_rec.country_code IS NULL THEN
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: -- location table name should be one of
250: -- PO_VENDOR_SITES_ALL, HR_LOCATIONS_ALL, HZ_LOCATIONS

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: -- Removed PO_VENDOR_SITES_ALL from the below if condition. Bug # 4584465
252:
253: IF UPPER(p_geo_struct_map_rec.loc_tbl_name) NOT IN ('HR_LOCATIONS_ALL',
254: 'HZ_LOCATIONS') THEN
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;

Line 258: RAISE FND_API.G_EXC_ERROR;

254: 'HZ_LOCATIONS') THEN
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');
257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260:
261: -- country should exist in fnd_territories
262:

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: FROM fnd_territories
267: WHERE territory_code = UPPER(p_geo_struct_map_rec.country_code);
268:
269: EXCEPTION WHEN NO_DATA_FOUND THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_INVALID');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274:

Line 273: RAISE FND_API.G_EXC_ERROR;

269: EXCEPTION WHEN NO_DATA_FOUND THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_INVALID');
272: FND_MSG_PUB.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274:
275: END;
276:
277: -- Address_style is nullable

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: -- At least one row is mandatory in map details
291: -- Not more than 10 rows can be passed in map details
292:
293: IF p_geo_struct_map_dtl_tbl.COUNT < 2 THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');
296: -- Please enter at least two location components.
297: FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;

Line 298: RAISE FND_API.G_EXC_ERROR;

294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');
296: -- Please enter at least two location components.
297: FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299:
300: ELSIF p_geo_struct_map_dtl_tbl.COUNT > 10 THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297: FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299:
300: ELSIF p_geo_struct_map_dtl_tbl.COUNT > 10 THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305:

Line 304: RAISE FND_API.G_EXC_ERROR;

300: ELSIF p_geo_struct_map_dtl_tbl.COUNT > 10 THEN
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305:
306: END IF;
307:
308: -- sort the map details table into a temporary

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: CLOSE c_determine_geo_element_col;
330: END IF;
331:
332: IF l_loc_seq_num IS NULL THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: l_error_code := 'HZ_GEO_EL_COL_NOT_FOUND';
335: l_token_name := 'GEOTYPE';
336: l_token_value := p_geo_struct_map_dtl_tbl(i).geo_type;
337: EXIT;

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: l_token_value := p_geo_struct_map_dtl_tbl(i).geo_type;
337: EXIT;
338: END IF;
339: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: l_error_code := 'HZ_GEO_LOC_COMP_MAND';
342: EXIT;
343: ELSE
344: check_valid_loc_comp(p_geo_struct_map_dtl_tbl(i).loc_comp, p_geo_struct_map_rec.loc_tbl_name,

Line 346: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

342: EXIT;
343: ELSE
344: check_valid_loc_comp(p_geo_struct_map_dtl_tbl(i).loc_comp, p_geo_struct_map_rec.loc_tbl_name,
345: x_return_status, l_error_code);
346: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
347: l_token_name := 'LOCCOMP';
348: l_token_value := p_geo_struct_map_dtl_tbl(i).loc_comp;
349: EXIT;
350: END IF;

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: EXIT;
350: END IF;
351: END IF;
352: IF p_geo_struct_map_dtl_tbl(i).geo_type IS NULL THEN
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: l_error_code := 'HZ_GEO_GEO_TYPE_MAND';
355: EXIT;
356: ELSE
357: check_valid_geo_type(p_geo_struct_map_dtl_tbl(i).geo_type, x_return_status, l_error_code);

Line 358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

354: l_error_code := 'HZ_GEO_GEO_TYPE_MAND';
355: EXIT;
356: ELSE
357: check_valid_geo_type(p_geo_struct_map_dtl_tbl(i).geo_type, x_return_status, l_error_code);
358: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
359: l_token_name := 'GEOTYPE';
360: l_token_value := p_geo_struct_map_dtl_tbl(i).geo_type;
361: EXIT;
362: END IF;

Line 370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

366: l_geo_struct_map_dtl_tbl(l_loc_seq_num).geo_type := p_geo_struct_map_dtl_tbl(i).geo_type;
367: i := p_geo_struct_map_dtl_tbl.next(i);
368: END LOOP;
369:
370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
371: FND_MESSAGE.SET_NAME('AR', l_error_code);
372: IF l_token_value IS NOT NULL THEN
373: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);
374: END IF;

Line 376: RAISE FND_API.G_EXC_ERROR;

372: IF l_token_value IS NOT NULL THEN
373: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);
374: END IF;
375: FND_MSG_PUB.ADD;
376: RAISE FND_API.G_EXC_ERROR;
377: END IF;
378: END;
379:
380: BEGIN

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: END;
379:
380: BEGIN
381: IF p_geo_struct_map_dtl_tbl.count <> l_geo_struct_map_dtl_tbl.count THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;

Line 385: RAISE FND_API.G_EXC_ERROR;

381: IF p_geo_struct_map_dtl_tbl.count <> l_geo_struct_map_dtl_tbl.count THEN
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: END;
389:

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: -- Find geography_element column for the others
393: BEGIN
394: i := l_geo_struct_map_dtl_tbl.first;
395: IF l_geo_struct_map_dtl_tbl(i).geo_type <> 'COUNTRY' THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
398: FND_MSG_PUB.ADD;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSE

Line 399: RAISE FND_API.G_EXC_ERROR;

395: IF l_geo_struct_map_dtl_tbl(i).geo_type <> 'COUNTRY' THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
398: FND_MSG_PUB.ADD;
399: RAISE FND_API.G_EXC_ERROR;
400: ELSE
401: l_geo_struct_map_dtl_tbl(i).geo_element_col := 'GEOGRAPHY_ELEMENT1';
402: END IF;
403: i := l_geo_struct_map_dtl_tbl.next(i);

Line 414: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

410: l_parent_geo_type,
411: p_geo_struct_map_rec.country_code,
412: l_geo_struct_map_dtl_tbl(i).geo_element_col,
413: x_return_status);
414: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
415: EXIT;
416: END IF;
417: i := l_geo_struct_map_dtl_tbl.next(i);
418: END LOOP;

Line 420: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

416: END IF;
417: i := l_geo_struct_map_dtl_tbl.next(i);
418: END LOOP;
419:
420: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
421: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('GEOTYPE',l_geo_struct_map_dtl_tbl(i).geo_type);
423: FND_MSG_PUB.ADD;
424: RAISE FND_API.G_EXC_ERROR;

Line 424: RAISE FND_API.G_EXC_ERROR;

420: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
421: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');
422: FND_MESSAGE.SET_TOKEN('GEOTYPE',l_geo_struct_map_dtl_tbl(i).geo_type);
423: FND_MSG_PUB.ADD;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426: END;
427:
428: -- Call table handler to insert row and make a

Line 474: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

470:
471: PROCEDURE create_geo_struct_mapping(
472: p_geo_struct_map_rec IN geo_struct_map_rec_type,
473: p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
474: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
475: x_map_id OUT NOCOPY NUMBER,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_count OUT NOCOPY NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 487: IF FND_API.to_Boolean(p_init_msg_list) THEN

483: -- Standard start of API savepoint
484: SAVEPOINT create_geo_struct_map;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean(p_init_msg_list) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- Initialize API return status to success.

Line 492: x_return_status := FND_API.G_RET_STS_SUCCESS;

488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- Initialize API return status to success.
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493:
494: -- Call to business logic.
495: do_create_geo_struct_mapping(
496: p_geo_struct_map_rec,

Line 503: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

499: x_return_status
500: );
501:
502: -- if validation failed at any point, then raise an exception to stop processing
503: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: -- Standard call to get message count and if count is 1, get message info.

Line 504: RAISE FND_API.G_EXC_ERROR;

500: );
501:
502: -- if validation failed at any point, then raise an exception to stop processing
503: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: -- Standard call to get message count and if count is 1, get message info.
508: FND_MSG_PUB.Count_And_Get(

Line 509: p_encoded => FND_API.G_FALSE,

505: END IF;
506:
507: -- Standard call to get message count and if count is 1, get message info.
508: FND_MSG_PUB.Count_And_Get(
509: p_encoded => FND_API.G_FALSE,
510: p_count => x_msg_count,
511: p_data => x_msg_data);
512:
513: EXCEPTION

Line 514: WHEN FND_API.G_EXC_ERROR THEN

510: p_count => x_msg_count,
511: p_data => x_msg_data);
512:
513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO create_geo_struct_map;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512:
513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO create_geo_struct_map;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);

Line 518: p_encoded => FND_API.G_FALSE,

514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO create_geo_struct_map;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO create_geo_struct_map;

Line 521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

517: FND_MSG_PUB.Count_And_Get(
518: p_encoded => FND_API.G_FALSE,
519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO create_geo_struct_map;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.Count_And_Get(
525: p_encoded => FND_API.G_FALSE,

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

519: p_count => x_msg_count,
520: p_data => x_msg_data);
521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO create_geo_struct_map;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.Count_And_Get(
525: p_encoded => FND_API.G_FALSE,
526: p_count => x_msg_count,
527: p_data => x_msg_data);

Line 525: p_encoded => FND_API.G_FALSE,

521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
522: ROLLBACK TO create_geo_struct_map;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.Count_And_Get(
525: p_encoded => FND_API.G_FALSE,
526: p_count => x_msg_count,
527: p_data => x_msg_data);
528:
529: WHEN DUP_VAL_ON_INDEX THEN

Line 531: x_return_status := FND_API.G_RET_STS_ERROR;

527: p_data => x_msg_data);
528:
529: WHEN DUP_VAL_ON_INDEX THEN
530: ROLLBACK TO create_geo_struct_map;
531: x_return_status := FND_API.G_RET_STS_ERROR;
532: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
533: IF p_index_name = 'HZ_GEO_STRUCT_MAP_U1' THEN
534: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_MAP_ID');
535: FND_MSG_PUB.ADD;

Line 557: p_encoded => FND_API.G_FALSE,

553: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_GEO_TYPE');
554: FND_MSG_PUB.ADD;
555: END IF;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_msg_count,
559: p_data => x_msg_data);
560: WHEN OTHERS THEN
561: ROLLBACK TO create_geo_struct_map;

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: p_count => x_msg_count,
559: p_data => x_msg_data);
560: WHEN OTHERS THEN
561: ROLLBACK TO create_geo_struct_map;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
565: FND_MSG_PUB.ADD;
566: FND_MSG_PUB.Count_And_Get(

Line 567: p_encoded => FND_API.G_FALSE,

563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
564: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
565: FND_MSG_PUB.ADD;
566: FND_MSG_PUB.Count_And_Get(
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570:
571: END create_geo_struct_mapping;

Line 579: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

575: p_location_table_name IN VARCHAR2,
576: p_country IN VARCHAR2,
577: p_address_style IN VARCHAR2,
578: p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
579: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
580: x_return_status OUT NOCOPY VARCHAR2,
581: x_msg_count OUT NOCOPY NUMBER,
582: x_msg_data OUT NOCOPY VARCHAR2
583: ) IS

Line 618: x_return_status := FND_API.G_RET_STS_SUCCESS;

614: -- delete row using country, address style, location table name
615: -- If above is not provided map_id should be provided, delete as
616: -- per map id.
617:
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: IF p_map_id IS NULL THEN
620: IF p_location_table_name IS NULL THEN
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');

Line 621: x_return_status := FND_API.G_RET_STS_ERROR;

617:
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: IF p_map_id IS NULL THEN
620: IF p_location_table_name IS NULL THEN
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;

Line 624: RAISE FND_API.G_EXC_ERROR;

620: IF p_location_table_name IS NULL THEN
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
623: FND_MSG_PUB.ADD;
624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626:
627: IF p_country IS NULL THEN
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: RAISE FND_API.G_EXC_ERROR;
625: END IF;
626:
627: IF p_country IS NULL THEN
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');
630: FND_MSG_PUB.ADD;
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;

Line 631: RAISE FND_API.G_EXC_ERROR;

627: IF p_country IS NULL THEN
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_COUNTRY_MAND');
630: FND_MSG_PUB.ADD;
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633:
634: IF p_address_style IS NULL THEN
635: BEGIN

Line 643: x_return_status := FND_API.G_RET_STS_ERROR;

639: WHERE country_code = p_country
640: AND loc_tbl_name = p_location_table_name
641: AND address_style IS NULL;
642: EXCEPTION WHEN NO_DATA_FOUND THEN
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
645: FND_MSG_PUB.ADD;
646:
647: END;

Line 648: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

644: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
645: FND_MSG_PUB.ADD;
646:
647: END;
648: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651: ELSE
652: BEGIN

Line 649: RAISE FND_API.G_EXC_ERROR;

645: FND_MSG_PUB.ADD;
646:
647: END;
648: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651: ELSE
652: BEGIN
653: SELECT map_id

Line 660: x_return_status := FND_API.G_RET_STS_ERROR;

656: WHERE country_code = p_country
657: AND loc_tbl_name = p_location_table_name
658: AND address_style = p_address_style;
659: EXCEPTION WHEN NO_DATA_FOUND THEN
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
662: FND_MSG_PUB.ADD;
663: END;
664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

660: x_return_status := FND_API.G_RET_STS_ERROR;
661: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
662: FND_MSG_PUB.ADD;
663: END;
664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667:
668: END IF;

Line 665: RAISE FND_API.G_EXC_ERROR;

661: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
662: FND_MSG_PUB.ADD;
663: END;
664: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667:
668: END IF;
669: ELSE

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: FROM hz_geo_struct_map
674: WHERE map_id = p_map_id;
675:
676: EXCEPTION WHEN NO_DATA_FOUND THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
679: FND_MSG_PUB.ADD;
680: END;
681:

Line 682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

678: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAPPING_ROW');
679: FND_MSG_PUB.ADD;
680: END;
681:
682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686: END IF;

Line 683: RAISE FND_API.G_EXC_ERROR;

679: FND_MSG_PUB.ADD;
680: END;
681:
682: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686: END IF;
687:

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710:
711: l_delete_mapping_also := 'Y';
712: EXCEPTION WHEN NO_DATA_FOUND THEN
713: /*
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');
716: -- At least two location components is required for the mapping
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_ERROR;

Line 718: RAISE FND_API.G_EXC_ERROR;

714: x_return_status := FND_API.G_RET_STS_ERROR;
715: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_2_MAP_DTL_MAND');
716: -- At least two location components is required for the mapping
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_ERROR;
719: */
720: -- only 1 mapping detail that will be deleted below, so just delete the
721: -- mapping itself.
722: l_delete_mapping_also := 'Y';

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

724:
725: END IF;
726:
727: IF p_geo_struct_map_dtl_tbl(i).geo_type = 'COUNTRY' THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
730: FND_MSG_PUB.ADD;
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;

Line 731: RAISE FND_API.G_EXC_ERROR;

727: IF p_geo_struct_map_dtl_tbl(i).geo_type = 'COUNTRY' THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEO_TYPE_NOT_COUNTRY');
730: FND_MSG_PUB.ADD;
731: RAISE FND_API.G_EXC_ERROR;
732: END IF;
733: END;
734:
735: -- If there is a record in the usage dtls table, detete that record before

Line 749: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

745: p_init_msg_list => 'F',
746: x_return_status => l_return_status,
747: x_msg_count => l_msg_count,
748: x_msg_data => l_msg_data);
749: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
750: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');
751: -- Error in Usage Delete API
752: FND_MSG_PUB.ADD;
753: RAISE FND_API.G_EXC_ERROR;

Line 753: RAISE FND_API.G_EXC_ERROR;

749: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
750: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');
751: -- Error in Usage Delete API
752: FND_MSG_PUB.ADD;
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: END LOOP;
756: CLOSE c_address_usage_dtls;
757:

Line 785: IF l_status = FND_API.G_RET_STS_ERROR THEN

781: -- call the genpkg to recreate gnr package.
782: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
783: BEGIN
784: hz_gnr_gen_pkg.genpkg(p_map_id,l_pkgname,l_status);
785: IF l_status = FND_API.G_RET_STS_ERROR THEN
786: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;

Line 788: RAISE FND_API.G_EXC_ERROR;

784: hz_gnr_gen_pkg.genpkg(p_map_id,l_pkgname,l_status);
785: IF l_status = FND_API.G_RET_STS_ERROR THEN
786: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
787: FND_MSG_PUB.ADD;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790: EXCEPTION WHEN OTHERS THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
792: FND_MSG_PUB.ADD;

Line 793: RAISE FND_API.G_EXC_ERROR;

789: END IF;
790: EXCEPTION WHEN OTHERS THEN
791: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: END;
795: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
796: */
797:

Line 817: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

813: p_init_msg_list => 'F',
814: x_return_status => l_return_status,
815: x_msg_count => l_msg_count,
816: x_msg_data => l_msg_data);
817: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
818: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');
819: -- Error in Usage Delete API
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;

Line 821: RAISE FND_API.G_EXC_ERROR;

817: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
818: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_IN_USAGE_DEL_API');
819: -- Error in Usage Delete API
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: END IF;
824:
825: EXIT WHEN c_address_usages%NOTFOUND;

Line 850: WHEN FND_API.G_EXC_ERROR THEN

846:
847: -- EXECUTE IMMEDIATE l_drp_sql;
848:
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);

Line 852: p_encoded => FND_API.G_FALSE,

848:
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:
856: WHEN OTHERS THEN

Line 861: p_encoded => FND_API.G_FALSE,

857: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
858: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
859: FND_MSG_PUB.ADD;
860: FND_MSG_PUB.Count_And_Get(
861: p_encoded => FND_API.G_FALSE,
862: p_count => x_msg_count,
863: p_data => x_msg_data);
864:
865: END delete_geo_struct_mapping;

Line 870: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

866:
867: PROCEDURE create_geo_struct_map_dtls
868: (p_map_id IN NUMBER,
869: p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
870: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
871: x_return_status OUT NOCOPY VARCHAR2,
872: x_msg_count OUT NOCOPY NUMBER,
873: x_msg_data OUT NOCOPY VARCHAR2
874: ) IS

Line 917: IF FND_API.to_Boolean(p_init_msg_list) THEN

913: -- Standard start of API savepoint
914: SAVEPOINT create_geo_struct_map_dtls;
915:
916: -- Initialize message list if p_init_msg_list is set to TRUE.
917: IF FND_API.to_Boolean(p_init_msg_list) THEN
918: FND_MSG_PUB.initialize;
919: END IF;
920:
921: -- Initialize API return status to success.

Line 922: x_return_status := FND_API.G_RET_STS_SUCCESS;

918: FND_MSG_PUB.initialize;
919: END IF;
920:
921: -- Initialize API return status to success.
922: x_return_status := FND_API.G_RET_STS_SUCCESS;
923:
924: l_country := NULL;
925: l_loc_tbl_name := NULL;
926: OPEN c_struct_map(p_map_id);

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: FETCH c_struct_map INTO l_country, l_loc_tbl_name;
928: CLOSE c_struct_map;
929:
930: IF (l_country IS NULL OR l_loc_tbl_name IS NULL) THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
933: -- Please pass a valid map ID that is not NULL.
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_ERROR;

Line 935: RAISE FND_API.G_EXC_ERROR;

931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
933: -- Please pass a valid map ID that is not NULL.
934: FND_MSG_PUB.ADD;
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: l_map_dtl_count := 0;
939: OPEN c_map_dtl_count(p_map_id);

Line 945: x_return_status := FND_API.G_RET_STS_ERROR;

941: CLOSE c_map_dtl_count;
942:
943: -- Not more than 10 rows can be created in map details
944: IF (p_geo_struct_map_dtl_tbl.COUNT+l_map_dtl_count) > 10 THEN
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;

Line 948: RAISE FND_API.G_EXC_ERROR;

944: IF (p_geo_struct_map_dtl_tbl.COUNT+l_map_dtl_count) > 10 THEN
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TOO_MANY_MAP_DTLS');
947: FND_MSG_PUB.ADD;
948: RAISE FND_API.G_EXC_ERROR;
949: END IF;
950:
951: -- sort the map details table into a temporary
952: -- table which will be indexed by loc_seq_num

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

973: CLOSE c_determine_geo_element_col;
974: END IF;
975:
976: IF (l_loc_seq_num IS NULL OR l_geo_element_column IS NULL) THEN
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');
979: FND_MESSAGE.SET_TOKEN('GEOTYPE',p_geo_struct_map_dtl_tbl(i).geo_type);
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;

Line 981: RAISE FND_API.G_EXC_ERROR;

977: x_return_status := FND_API.G_RET_STS_ERROR;
978: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_EL_COL_NOT_FOUND');
979: FND_MESSAGE.SET_TOKEN('GEOTYPE',p_geo_struct_map_dtl_tbl(i).geo_type);
980: FND_MSG_PUB.ADD;
981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:
984: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:
984: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: l_error_code := 'HZ_GEO_LOC_COMP_MAND';
987: EXIT;
988: ELSE
989: check_valid_loc_comp(p_geo_struct_map_dtl_tbl(i).loc_comp, l_loc_tbl_name,

Line 991: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

987: EXIT;
988: ELSE
989: check_valid_loc_comp(p_geo_struct_map_dtl_tbl(i).loc_comp, l_loc_tbl_name,
990: x_return_status, l_error_code);
991: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
992: l_token_name := 'LOCCOMP';
993: l_token_value := p_geo_struct_map_dtl_tbl(i).loc_comp;
994: EXIT;
995: END IF;

Line 999: x_return_status := FND_API.G_RET_STS_ERROR;

995: END IF;
996: END IF;
997:
998: IF p_geo_struct_map_dtl_tbl(i).geo_type IS NULL THEN
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: l_error_code := 'HZ_GEO_GEO_TYPE_MAND';
1001: EXIT;
1002: ELSE
1003: check_valid_geo_type(p_geo_struct_map_dtl_tbl(i).geo_type, x_return_status, l_error_code);

Line 1004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1000: l_error_code := 'HZ_GEO_GEO_TYPE_MAND';
1001: EXIT;
1002: ELSE
1003: check_valid_geo_type(p_geo_struct_map_dtl_tbl(i).geo_type, x_return_status, l_error_code);
1004: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1005: l_token_name := 'GEOTYPE';
1006: l_token_value := p_geo_struct_map_dtl_tbl(i).geo_type;
1007: EXIT;
1008: END IF;

Line 1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1016: i := p_geo_struct_map_dtl_tbl.next(i);
1017:
1018: END LOOP;
1019:
1020: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1021: FND_MESSAGE.SET_NAME('AR', l_error_code);
1022: IF l_token_value IS NOT NULL THEN
1023: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);
1024: END IF;

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: IF l_token_value IS NOT NULL THEN
1023: FND_MESSAGE.SET_TOKEN(l_token_name, l_token_value);
1024: END IF;
1025: FND_MSG_PUB.ADD;
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: END;
1029:
1030: -- Call table handler to insert row and make a

Line 1049: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1045: END LOOP;
1046: END; -- insert row
1047:
1048: -- if validation failed at any point, then raise an exception to stop processing
1049: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052:
1053: -- Standard call to get message count and if count is 1, get message info.

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: END; -- insert row
1047:
1048: -- if validation failed at any point, then raise an exception to stop processing
1049: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052:
1053: -- Standard call to get message count and if count is 1, get message info.
1054: FND_MSG_PUB.Count_And_Get(

Line 1055: p_encoded => FND_API.G_FALSE,

1051: END IF;
1052:
1053: -- Standard call to get message count and if count is 1, get message info.
1054: FND_MSG_PUB.Count_And_Get(
1055: p_encoded => FND_API.G_FALSE,
1056: p_count => x_msg_count,
1057: p_data => x_msg_data);
1058:
1059: EXCEPTION

Line 1060: WHEN FND_API.G_EXC_ERROR THEN

1056: p_count => x_msg_count,
1057: p_data => x_msg_data);
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO create_geo_struct_map_dtls;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: FND_MSG_PUB.Count_And_Get(
1064: p_encoded => FND_API.G_FALSE,

Line 1062: x_return_status := FND_API.G_RET_STS_ERROR;

1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO create_geo_struct_map_dtls;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: FND_MSG_PUB.Count_And_Get(
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data);

Line 1064: p_encoded => FND_API.G_FALSE,

1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO create_geo_struct_map_dtls;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: FND_MSG_PUB.Count_And_Get(
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data);
1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1068: ROLLBACK TO create_geo_struct_map_dtls;

Line 1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1063: FND_MSG_PUB.Count_And_Get(
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data);
1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1068: ROLLBACK TO create_geo_struct_map_dtls;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_encoded => FND_API.G_FALSE,

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: p_count => x_msg_count,
1066: p_data => x_msg_data);
1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1068: ROLLBACK TO create_geo_struct_map_dtls;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_encoded => FND_API.G_FALSE,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data);

Line 1071: p_encoded => FND_API.G_FALSE,

1067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1068: ROLLBACK TO create_geo_struct_map_dtls;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_encoded => FND_API.G_FALSE,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data);
1074: WHEN DUP_VAL_ON_INDEX THEN
1075: ROLLBACK TO create_geo_struct_map_dtls;

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR;

1072: p_count => x_msg_count,
1073: p_data => x_msg_data);
1074: WHEN DUP_VAL_ON_INDEX THEN
1075: ROLLBACK TO create_geo_struct_map_dtls;
1076: x_return_status := FND_API.G_RET_STS_ERROR;
1077: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1078:
1079: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1080: -- FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');

Line 1098: p_encoded => FND_API.G_FALSE,

1094: FND_MSG_PUB.ADD;
1095: END IF;
1096:
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101: WHEN OTHERS THEN
1102: ROLLBACK TO create_geo_struct_map_dtls;

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101: WHEN OTHERS THEN
1102: ROLLBACK TO create_geo_struct_map_dtls;
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1105: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1106: FND_MSG_PUB.ADD;
1107: FND_MSG_PUB.Count_And_Get(

Line 1108: p_encoded => FND_API.G_FALSE,

1104: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1105: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1106: FND_MSG_PUB.ADD;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: END create_geo_struct_map_dtls;

Line 1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1113:
1114: PROCEDURE update_geo_struct_map_dtls
1115: (p_map_id IN NUMBER,
1116: p_geo_struct_map_dtl_tbl IN geo_struct_map_dtl_tbl_type,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: x_return_status OUT NOCOPY VARCHAR2,
1119: x_msg_count OUT NOCOPY NUMBER,
1120: x_msg_data OUT NOCOPY VARCHAR2
1121: ) IS

Line 1155: IF FND_API.to_Boolean(p_init_msg_list) THEN

1151: -- Standard start of API savepoint
1152: SAVEPOINT update_geo_struct_map_dtls;
1153:
1154: -- Initialize message list if p_init_msg_list is set to TRUE.
1155: IF FND_API.to_Boolean(p_init_msg_list) THEN
1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: -- Initialize API return status to success.

Line 1160: x_return_status := FND_API.G_RET_STS_SUCCESS;

1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: -- Initialize API return status to success.
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161:
1162: l_country := NULL;
1163: l_loc_tbl_name := NULL;
1164: OPEN c_struct_map(p_map_id);

Line 1169: x_return_status := FND_API.G_RET_STS_ERROR;

1165: FETCH c_struct_map INTO l_country, l_loc_tbl_name;
1166: CLOSE c_struct_map;
1167:
1168: IF (l_country IS NULL OR l_loc_tbl_name IS NULL) THEN
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
1171: -- Please pass a valid map ID that is not NULL.
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_MAP_ID');
1171: -- Please pass a valid map ID that is not NULL.
1172: FND_MSG_PUB.ADD;
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176: IF p_geo_struct_map_dtl_tbl.COUNT > 0 THEN
1177: i := p_geo_struct_map_dtl_tbl.FIRST;

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

1183: FETCH c_struct_map_dtl INTO l_rowid, l_loc_seq_num, l_geo_element_column;
1184: CLOSE c_struct_map_dtl;
1185:
1186: IF (l_loc_seq_num IS NULL OR l_geo_element_column IS NULL) THEN
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');
1189: -- A mapping does not exist for this geography type. Please map the geography type.
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GEOTYPE_INVALID');
1189: -- A mapping does not exist for this geography type. Please map the geography type.
1190: FND_MSG_PUB.ADD;
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193:
1194: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN
1195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1195: x_return_status := FND_API.G_RET_STS_ERROR;

1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193:
1194: IF p_geo_struct_map_dtl_tbl(i).loc_comp IS NULL THEN
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: l_error_code := 'HZ_GEO_LOC_COMP_MAND';
1197: EXIT;
1198: ELSE
1199: check_valid_loc_comp(p_geo_struct_map_dtl_tbl(i).loc_comp, l_loc_tbl_name,

Line 1201: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1197: EXIT;
1198: ELSE
1199: check_valid_loc_comp(p_geo_struct_map_dtl_tbl(i).loc_comp, l_loc_tbl_name,
1200: x_return_status, l_error_code);
1201: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1202: l_token_name := 'LOCCOMP';
1203: l_token_value := p_geo_struct_map_dtl_tbl(i).loc_comp;
1204: EXIT;
1205: END IF;

Line 1221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1217: i := p_geo_struct_map_dtl_tbl.NEXT(i);
1218: END LOOP;
1219:
1220: -- if validation failed at any point, then raise an exception to stop processing
1221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1222: RAISE FND_API.G_EXC_ERROR;
1223: END IF;
1224:
1225: SELECT count(*)

Line 1222: RAISE FND_API.G_EXC_ERROR;

1218: END LOOP;
1219:
1220: -- if validation failed at any point, then raise an exception to stop processing
1221: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1222: RAISE FND_API.G_EXC_ERROR;
1223: END IF;
1224:
1225: SELECT count(*)
1226: INTO l_count

Line 1237: IF l_status = FND_API.G_RET_STS_ERROR THEN

1233: IF l_count > 0 THEN
1234: --dbms_output.put_line('Before Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
1235: BEGIN
1236: hz_gnr_gen_pkg.genpkg(p_map_id,l_pkgname,l_status);
1237: IF l_status = FND_API.G_RET_STS_ERROR THEN
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236: hz_gnr_gen_pkg.genpkg(p_map_id,l_pkgname,l_status);
1237: IF l_status = FND_API.G_RET_STS_ERROR THEN
1238: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_PKG_ERR');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242: EXCEPTION WHEN OTHERS THEN
1243: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
1244: FND_MSG_PUB.ADD;

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: END IF;
1242: EXCEPTION WHEN OTHERS THEN
1243: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_GNR_INTERNAL_ERROR');
1244: FND_MSG_PUB.ADD;
1245: RAISE FND_API.G_EXC_ERROR;
1246: END;
1247: --dbms_output.put_line('After Gen pkg Create usage : map id :'|| p_address_usages_rec.map_id);
1248: END IF;
1249:

Line 1254: p_encoded => FND_API.G_FALSE,

1250: END IF;
1251:
1252: -- Standard call to get message count and if count is 1, get message info.
1253: FND_MSG_PUB.Count_And_Get(
1254: p_encoded => FND_API.G_FALSE,
1255: p_count => x_msg_count,
1256: p_data => x_msg_data);
1257:
1258: EXCEPTION

Line 1259: WHEN FND_API.G_EXC_ERROR THEN

1255: p_count => x_msg_count,
1256: p_data => x_msg_data);
1257:
1258: EXCEPTION
1259: WHEN FND_API.G_EXC_ERROR THEN
1260: ROLLBACK TO update_geo_struct_map_dtls;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_encoded => FND_API.G_FALSE,

Line 1261: x_return_status := FND_API.G_RET_STS_ERROR;

1257:
1258: EXCEPTION
1259: WHEN FND_API.G_EXC_ERROR THEN
1260: ROLLBACK TO update_geo_struct_map_dtls;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_encoded => FND_API.G_FALSE,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);

Line 1263: p_encoded => FND_API.G_FALSE,

1259: WHEN FND_API.G_EXC_ERROR THEN
1260: ROLLBACK TO update_geo_struct_map_dtls;
1261: x_return_status := FND_API.G_RET_STS_ERROR;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_encoded => FND_API.G_FALSE,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO update_geo_struct_map_dtls;

Line 1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1262: FND_MSG_PUB.Count_And_Get(
1263: p_encoded => FND_API.G_FALSE,
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO update_geo_struct_map_dtls;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_encoded => FND_API.G_FALSE,

Line 1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1264: p_count => x_msg_count,
1265: p_data => x_msg_data);
1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO update_geo_struct_map_dtls;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);

Line 1270: p_encoded => FND_API.G_FALSE,

1266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1267: ROLLBACK TO update_geo_struct_map_dtls;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: FND_MSG_PUB.Count_And_Get(
1270: p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273: WHEN DUP_VAL_ON_INDEX THEN
1274: ROLLBACK TO update_geo_struct_map_dtls;

Line 1275: x_return_status := FND_API.G_RET_STS_ERROR;

1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273: WHEN DUP_VAL_ON_INDEX THEN
1274: ROLLBACK TO update_geo_struct_map_dtls;
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1277:
1278: IF p_index_name = 'HZ_GEO_STRUCT_MAP_DTL_U1' THEN
1279: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_LOC_SEQ_NUM');

Line 1292: p_encoded => FND_API.G_FALSE,

1288: FND_MSG_PUB.ADD;
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get(
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: WHEN OTHERS THEN
1296: ROLLBACK TO update_geo_struct_map_dtls;

Line 1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1293: p_count => x_msg_count,
1294: p_data => x_msg_data);
1295: WHEN OTHERS THEN
1296: ROLLBACK TO update_geo_struct_map_dtls;
1297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(

Line 1302: p_encoded => FND_API.G_FALSE,

1298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1299: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1300: FND_MSG_PUB.ADD;
1301: FND_MSG_PUB.Count_And_Get(
1302: p_encoded => FND_API.G_FALSE,
1303: p_count => x_msg_count,
1304: p_data => x_msg_data);
1305:
1306: END update_geo_struct_map_dtls;