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.ZX_TCM_GEO_JUR_PKG dependencies on FND_API

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: END IF;
62:
63: -- Initialize API return status to success.
64:
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: l_party_type_tbl_idx := dbms_utility.get_hash_value(p_party_type, 1, 8192);
68:
69: IF (ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE.exists(l_party_type_tbl_idx)) THEN

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: END IF;
119:
120: EXCEPTION WHEN OTHERS THEN
121: -- Party type information could not be retrived.
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_PARTY_TYPE_INFO');
124:
125: -- Logging Infra: Statement level
126: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 217: x_return_status := FND_API.G_RET_STS_SUCCESS;

213: l_log_msg := l_procedure_name||'(+)';
214: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
215: END IF;
216:
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
219:
220: x_location_info_rec := zx_global_Structures_pkg.loc_info_tbl(to_char(p_location_id));
221:

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: l_log_msg := l_log_msg ||' E: SEL country_code: no_data_found: p_location_id='||p_location_id;
261: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
262: END IF;
263:
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
266: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
267: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
268: RAISE FND_API.G_EXC_ERROR;

Line 268: RAISE FND_API.G_EXC_ERROR;

264: x_return_status := FND_API.G_RET_STS_ERROR;
265: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
266: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
267: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
268: RAISE FND_API.G_EXC_ERROR;
269: END;
270: END;
271:
272: ELSIF p_location_table_name = 'HZ_LOCATIONS' THEN

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: l_log_msg := 'E: SEL country_code: no_data_found: p_location_id='||p_location_id;
308: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
309: END IF;
310:
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
313: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
314: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
315: RAISE FND_API.G_EXC_ERROR;

Line 315: RAISE FND_API.G_EXC_ERROR;

311: x_return_status := FND_API.G_RET_STS_ERROR;
312: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
313: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
314: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
315: RAISE FND_API.G_EXC_ERROR;
316: END;
317: END;
318: END IF;
319: END IF; -- Loc_info_tbl.exists

Line 354: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

350: zx_valid_init_params_pkg.source_rec.ship_from_party_type, x_location_table_name,
351: l_loc_site,
352: x_return_status);
353:
354: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;
357:
358: ELSIF p_location_type = 'SHIP_TO' THEN

Line 355: RAISE FND_API.G_EXC_ERROR;

351: l_loc_site,
352: x_return_status);
353:
354: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;
357:
358: ELSIF p_location_type = 'SHIP_TO' THEN
359: get_pos_loc_or_site(

Line 365: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

361: x_location_table_name,
362: l_loc_site,
363: x_return_status);
364:
365: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368:
369: ELSIF p_location_type = 'BILL_FROM' THEN

Line 366: RAISE FND_API.G_EXC_ERROR;

362: l_loc_site,
363: x_return_status);
364:
365: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
366: RAISE FND_API.G_EXC_ERROR;
367: END IF;
368:
369: ELSIF p_location_type = 'BILL_FROM' THEN
370: get_pos_loc_or_site(

Line 374: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

370: get_pos_loc_or_site(
371: zx_valid_init_params_pkg.source_rec.bill_from_party_type, x_location_table_name,
372: l_loc_site,
373: x_return_status);
374: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: ELSIF p_location_type = 'BILL_TO' THEN

Line 375: RAISE FND_API.G_EXC_ERROR;

371: zx_valid_init_params_pkg.source_rec.bill_from_party_type, x_location_table_name,
372: l_loc_site,
373: x_return_status);
374: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: ELSIF p_location_type = 'BILL_TO' THEN
379: get_pos_loc_or_site(

Line 384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

380: zx_valid_init_params_pkg.source_rec.bill_to_party_type,
381: x_location_table_name,
382: l_loc_site,
383: x_return_status);
384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: ELSIF p_location_type = 'POA' THEN

Line 385: RAISE FND_API.G_EXC_ERROR;

381: x_location_table_name,
382: l_loc_site,
383: x_return_status);
384: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: ELSIF p_location_type = 'POA' THEN
389: get_pos_loc_or_site(

Line 394: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

390: zx_valid_init_params_pkg.source_rec.poa_party_type,
391: x_location_table_name,
392: l_loc_site,
393: x_return_status);
394: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: ELSIF p_location_type = 'POO' THEN

Line 395: RAISE FND_API.G_EXC_ERROR;

391: x_location_table_name,
392: l_loc_site,
393: x_return_status);
394: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: ELSIF p_location_type = 'POO' THEN
399: get_pos_loc_or_site(

Line 404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

400: zx_valid_init_params_pkg.source_rec.poo_party_type,
401: x_location_table_name,
402: l_loc_site,
403: x_return_status);
404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: ELSIF p_location_type = 'TRADING_HQ' THEN

Line 405: RAISE FND_API.G_EXC_ERROR;

401: x_location_table_name,
402: l_loc_site,
403: x_return_status);
404: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: ELSIF p_location_type = 'TRADING_HQ' THEN
409: get_pos_loc_or_site(

Line 414: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

410: zx_valid_init_params_pkg.source_rec.trad_hq_party_type,
411: x_location_table_name,
412: l_loc_site,
413: x_return_status);
414: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:
418: ELSIF p_location_type = 'OWN_HQ' THEN

Line 415: RAISE FND_API.G_EXC_ERROR;

411: x_location_table_name,
412: l_loc_site,
413: x_return_status);
414: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:
418: ELSIF p_location_type = 'OWN_HQ' THEN
419: get_pos_loc_or_site(

Line 423: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

419: get_pos_loc_or_site(
420: zx_valid_init_params_pkg.source_rec.own_hq_party_type, x_location_table_name,
421: l_loc_site,
422: x_return_status);
423: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: ELSIF p_location_type = 'TITLE_TRANS' THEN

Line 424: RAISE FND_API.G_EXC_ERROR;

420: zx_valid_init_params_pkg.source_rec.own_hq_party_type, x_location_table_name,
421: l_loc_site,
422: x_return_status);
423: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: ELSIF p_location_type = 'TITLE_TRANS' THEN
428: get_pos_loc_or_site(

Line 433: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

429: zx_valid_init_params_pkg.source_rec.ttl_trns_party_type,
430: x_location_table_name,
431: l_loc_site,
432: x_return_status);
433: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: ELSIF p_location_type = 'PAYING' THEN

Line 434: RAISE FND_API.G_EXC_ERROR;

430: x_location_table_name,
431: l_loc_site,
432: x_return_status);
433: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
434: RAISE FND_API.G_EXC_ERROR;
435: END IF;
436:
437: ELSIF p_location_type = 'PAYING' THEN
438: get_pos_loc_or_site(

Line 443: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

439: zx_valid_init_params_pkg.source_rec.paying_party_type,
440: x_location_table_name,
441: l_loc_site,
442: x_return_status);
443: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: ELSIF p_location_type = 'POC' THEN

Line 444: RAISE FND_API.G_EXC_ERROR;

440: x_location_table_name,
441: l_loc_site,
442: x_return_status);
443: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: ELSIF p_location_type = 'POC' THEN
448: /*get_pos_loc_or_site(

Line 461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

457: zx_valid_init_params_pkg.source_rec.poi_party_type,
458: x_location_table_name,
459: l_loc_site,
460: x_return_status);
461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465: ELSIF p_location_type = 'POD' THEN

Line 462: RAISE FND_API.G_EXC_ERROR;

458: x_location_table_name,
459: l_loc_site,
460: x_return_status);
461: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465: ELSIF p_location_type = 'POD' THEN
466: get_pos_loc_or_site(

Line 471: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

467: zx_valid_init_params_pkg.source_rec.pod_party_type,
468: x_location_table_name,
469: l_loc_site,
470: x_return_status);
471: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: ELSIF p_location_type = 'INTERNAL_ORG' THEN

Line 472: RAISE FND_API.G_EXC_ERROR;

468: x_location_table_name,
469: l_loc_site,
470: x_return_status);
471: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: ELSIF p_location_type = 'INTERNAL_ORG' THEN
476: x_location_table_name := 'HR_LOCATIONS_ALL';

Line 489: WHEN FND_API.G_EXC_ERROR THEN

485: END IF;
486:
487: EXCEPTION
488:
489: WHEN FND_API.G_EXC_ERROR THEN
490: x_return_status :=FND_API.G_RET_STS_ERROR;
491:
492: END get_location_table_name;
493:

Line 490: x_return_status :=FND_API.G_RET_STS_ERROR;

486:
487: EXCEPTION
488:
489: WHEN FND_API.G_EXC_ERROR THEN
490: x_return_status :=FND_API.G_RET_STS_ERROR;
491:
492: END get_location_table_name;
493:
494:

Line 646: x_return_status := FND_API.G_RET_STS_SUCCESS;

642: END IF;
643:
644: -- Initialize API return status to success.
645:
646: x_return_status := FND_API.G_RET_STS_SUCCESS;
647:
648: -- Derive location table name based on location_type
649: IF ZX_GLOBAL_STRUCTURES_PKG.Loc_info_tbl.exists(to_char(p_location_id)) then
650:

Line 753: x_return_status := FND_API.G_RET_STS_ERROR;

749:
750: END IF;
751:
752: IF l_count_geo = 0 THEN
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MESSAGE.SET_NAME('ZX', 'ZX_GEO_NO_GEO_NAME_REF');
755: --FND_MESSAGE.SET_TOKEN('LOCATION_TYPE', p_location_type);
756: RAISE FND_API.G_EXC_ERROR;
757: END IF;

Line 756: RAISE FND_API.G_EXC_ERROR;

752: IF l_count_geo = 0 THEN
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MESSAGE.SET_NAME('ZX', 'ZX_GEO_NO_GEO_NAME_REF');
755: --FND_MESSAGE.SET_TOKEN('LOCATION_TYPE', p_location_type);
756: RAISE FND_API.G_EXC_ERROR;
757: END IF;
758: END IF;
759:
760: -- Once table name is got, call TCA's get_zone API

Line 824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

820: ||' x_msg_data:'||x_msg_data
821: ||'number of records in x_zone_tbl :'||x_zone_tbl.count);
822: END IF;
823:
824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
825: ZX_API_PUB.G_EXTERNAL_API_CALL := 'Y';
826: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
827: IF x_msg_count = 1
828: THEN

Line 834: FND_MSG_PUB.GET(p_msg_index => i, p_encoded => FND_API.G_FALSE));

830: ELSIF x_msg_count > 1
831: THEN
832: FOR i in 1..x_msg_count LOOP
833: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name,
834: FND_MSG_PUB.GET(p_msg_index => i, p_encoded => FND_API.G_FALSE));
835: END LOOP;
836: END IF;
837: END IF;
838: END IF;

Line 896: WHEN FND_API.G_EXC_ERROR THEN

892:
893: END IF;
894:
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898:
899: -- Logging Infra: Statement level: "E" means "E"rror
900: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: END IF;
894:
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898:
899: -- Logging Infra: Statement level: "E" means "E"rror
900: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
901: IF x_zone_tbl.count > 0 THEN

Line 903: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||

899: -- Logging Infra: Statement level: "E" means "E"rror
900: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
901: IF x_zone_tbl.count > 0 THEN
902: FOR i in x_zone_tbl.first..x_zone_tbl.last LOOP
903: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_zone_id='||x_zone_tbl(i).zone_id||', x_zone_code='||x_zone_tbl(i).zone_code||
904: ', x_zone_name='||x_zone_tbl(i).zone_name||', x_return_status='||x_return_status;
905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
906: END LOOP;
907: END IF;

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: END IF;
908: END IF;
909:
910: WHEN OTHERS THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
913: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
914:
915: IF C_GEOGRAPHY_TYPES%ISOPEN THEN

Line 997: x_return_status := FND_API.G_RET_STS_SUCCESS;

993:
994:
995: -- Initialize API return status to success.
996:
997: x_return_status := FND_API.G_RET_STS_SUCCESS;
998:
999: l_jurisdiction_rec_tmp_tbl.delete;
1000: x_jurisdictions_found := 'N';
1001:

Line 1009: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1005: l_tax_regime_rec,
1006: x_return_status,
1007: l_error_buffer);
1008:
1009: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1010: IF (g_level_exception >= g_current_runtime_level ) THEN
1011:
1012: l_log_msg := 'Incorrect return_status after calling ' ||
1013: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info

Line 1122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1118: l_tax_rec,
1119: x_return_status,
1120: l_error_buffer);
1121:
1122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1123: IF (g_level_exception >= g_current_runtime_level ) THEN
1124:
1125: l_log_msg := 'Incorrect return_status after calling ' ||
1126: 'ZX_TDS_UTILITIES_PKG.get_regime_cache_info

Line 1207: l_obj_geo_type := FND_API.G_MISS_CHAR;

1203: WHERE subject_type = g_geography_use_info_tbl(l_tbl_index).geography_type
1204: AND object_type = 'CITY';
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: l_obj_geo_type := FND_API.G_MISS_CHAR;
1208: END;
1209: ELSIF g_geography_use_info_tbl(l_tbl_index).geography_use = 'MASTER_REF' THEN
1210: l_obj_geo_type := g_geography_use_info_tbl(l_tbl_index).geography_type;
1211: END IF;

Line 1213: l_obj_geo_type := FND_API.G_MISS_CHAR;

1209: ELSIF g_geography_use_info_tbl(l_tbl_index).geography_use = 'MASTER_REF' THEN
1210: l_obj_geo_type := g_geography_use_info_tbl(l_tbl_index).geography_type;
1211: END IF;
1212: ELSE
1213: l_obj_geo_type := FND_API.G_MISS_CHAR;
1214: END IF;
1215:
1216: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1217: l_log_msg := 'Geography Usage: ' || g_geography_use_info_tbl(l_tbl_index).geography_use ||

Line 1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1309: ----- l_log_msg := 'B: geography info: geography_id='||l_geography_id(i)||', geography_name='||l_geography_name(i)||
1310: ----- ', x_return_status='||x_return_status;
1311: ----- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1312: ----- END IF;
1313: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1314: IF l_zone_tbl.count > 0 THEN
1315: FOR j in l_zone_tbl.first..l_zone_tbl.last LOOP
1316: l_geography_id := l_zone_tbl(j).zone_id;
1317: get_jurisdiction(p_tax,

Line 1340: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1336: l_log_msg := 'B: geography info: geography_id='||l_geography_id||', geography_name='||l_geography_name||
1337: ', x_return_status='||x_return_status;
1338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1339: END IF;
1340: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1341: IF l_geography_id IS NOT NULL THEN
1342: get_jurisdiction(p_tax,
1343: p_tax_regime_code,
1344: l_geography_id ,

Line 1421: WHEN FND_API.G_EXC_ERROR THEN

1417: l_log_msg := l_procedure_name||'(-)';
1418: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.end', l_log_msg);
1419: END IF;
1420: EXCEPTION
1421: WHEN FND_API.G_EXC_ERROR THEN
1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423:
1424: -- Logging Infra: Statement level
1425: ---- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1422: x_return_status := FND_API.G_RET_STS_ERROR;

1418: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.end', l_log_msg);
1419: END IF;
1420: EXCEPTION
1421: WHEN FND_API.G_EXC_ERROR THEN
1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423:
1424: -- Logging Infra: Statement level
1425: ---- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1426: ---- l_log_msg := 'E: EXC: FND_API.G_EXEC_ERROR: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||

Line 1426: ---- l_log_msg := 'E: EXC: FND_API.G_EXEC_ERROR: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||

1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423:
1424: -- Logging Infra: Statement level
1425: ---- IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1426: ---- l_log_msg := 'E: EXC: FND_API.G_EXEC_ERROR: tax_jurisdiction_id='||g_jurisdiction_rec_tbl.tax_jurisdiction_id(i)||
1427: ---- ', tax_jurisdiction_code='||g_jurisdiction_rec_tbl.tax_jurisdiction_code(i);
1428: ---- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1429: ---- END IF;
1430:

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1429: ---- END IF;
1430:
1431:
1432: WHEN OTHERS THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1435: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1436:
1437: -- Logging Infra: Statement level

Line 1480: x_return_status := FND_API.G_RET_STS_SUCCESS;

1476: l_log_msg := l_log_msg||' B: SEL hz_geography_types: in: p_geography_type='||p_geography_type;
1477: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name || '.begin', l_log_msg);
1478: END IF;
1479:
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: /* nipatel commented out this validation because the call to get_master_geography is
1483: being made from within this package itself and there we are already fetching the
1484: goegoraphy type from hz_geography_types_b and the call is made only when geograpy_use

Line 1502: --x_return_status := FND_API.G_RET_STS_ERROR;

1498: l_log_msg := 'E: SEL hz_geography_types: no_data_found: '||'p_geography_type='||p_geography_type;
1499: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1500: END IF;
1501:
1502: --x_return_status := FND_API.G_RET_STS_ERROR;
1503: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TYPE_INVALID');
1504: RAISE FND_API.G_EXC_ERROR;
1505: END IF;
1506: -- ---------------------

Line 1504: RAISE FND_API.G_EXC_ERROR;

1500: END IF;
1501:
1502: --x_return_status := FND_API.G_RET_STS_ERROR;
1503: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TYPE_INVALID');
1504: RAISE FND_API.G_EXC_ERROR;
1505: END IF;
1506: -- ---------------------
1507: */
1508: get_location_table_name(p_location_type,

Line 1608: x_return_status := FND_API.G_RET_STS_ERROR;

1604: G_MODULE_NAME || l_procedure_name,
1605: l_log_msg);
1606: END IF;
1607:
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_COUNTRY');
1610: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
1611: FND_MESSAGE.SET_TOKEN('TABLE_NAME', x_location_table_name);
1612: RAISE FND_API.G_EXC_ERROR;

Line 1612: RAISE FND_API.G_EXC_ERROR;

1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_COUNTRY');
1610: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
1611: FND_MESSAGE.SET_TOKEN('TABLE_NAME', x_location_table_name);
1612: RAISE FND_API.G_EXC_ERROR;
1613: END;
1614: ELSE
1615:
1616:

Line 1624: x_return_status := FND_API.G_RET_STS_SUCCESS;

1620: l_log_msg := 'S: hz_geo_no_geo_name_ref: p_geography_type='||p_geography_type;
1621: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1622: END IF;
1623:
1624: x_return_status := FND_API.G_RET_STS_SUCCESS;
1625:
1626: END IF; -- p_geography_type = 'COUNTRY'
1627: END IF; --x_geography_id IS NULL
1628:

Line 1637: WHEN FND_API.G_EXC_ERROR THEN

1633: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1634: END IF;
1635:
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639:
1640: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1641: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_geography_id='||

Line 1638: x_return_status := FND_API.G_RET_STS_ERROR;

1634: END IF;
1635:
1636: EXCEPTION
1637: WHEN FND_API.G_EXC_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639:
1640: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1641: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_geography_id='||
1642: x_geography_id||', x_gegraphy_code='||x_geography_code||',

Line 1641: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_geography_id='||

1637: WHEN FND_API.G_EXC_ERROR THEN
1638: x_return_status := FND_API.G_RET_STS_ERROR;
1639:
1640: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1641: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR: x_geography_id='||
1642: x_geography_id||', x_gegraphy_code='||x_geography_code||',
1643: x_geography_name='||x_geography_name;
1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);
1645: END IF;

Line 1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1644: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||l_procedure_name,l_log_msg);
1645: END IF;
1646:
1647: WHEN OTHERS THEN
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1650: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1651:
1652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1743: x_return_status := FND_API.G_RET_STS_SUCCESS;

1739: END IF;
1740:
1741: -- Initialize API return status to success.
1742:
1743: x_return_status := FND_API.G_RET_STS_SUCCESS;
1744:
1745: IF location_type_tbl.count > 0 THEN
1746:
1747: FOR i IN location_type_tbl.first..location_type_tbl.last LOOP