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

Line 66: x_return_status := FND_API.G_RET_STS_SUCCESS;

62: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS.BEGIN',
63: 'ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_FROM_SOURCE_DOC(+)');
64: END IF;
65:
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: x_default := 'N';
68:
69: IF (g_level_statement >= g_current_runtime_level ) THEN
70: FND_LOG.STRING(g_level_statement,

Line 216: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

212: l_upg_trx_info_rec.trx_id := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index);
213: ZX_ON_FLY_TRX_UPGRADE_PKG.upgrade_trx_on_fly(p_upg_trx_info_rec => l_upg_trx_info_rec,
214: x_return_status => x_return_status
215: );
216: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT,
219: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
220: ' RETURN_STATUS = ' || x_return_status);

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: ' taxation_country = ' || p_taxation_country||
412: ' document_sub_type = ' || p_document_sub_type);
413: END IF;
414:
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: l_trx_date := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE(p_trx_line_index);
418:
419: l_country_code := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY(p_trx_line_index);

Line 465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

461: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(p_trx_line_index),
462: l_country_code,
463: x_return_status );
464:
465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: IF (g_level_error >= g_current_runtime_level ) THEN
467: FND_LOG.STRING(g_level_error,
468: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
469: 'Incorrect return_status after calling ' ||

Line 538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

534: p_org_id => NULL,
535: p_default_code => l_document_sub_type,
536: p_return_status => x_return_status);
537:
538: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
539: IF (g_level_error >= g_current_runtime_level ) THEN
540: FND_LOG.STRING(g_level_error,
541: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
542: 'Incorrect return_status after calling ' ||

Line 598: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

594: JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR(
595: p_trx_line_index => p_trx_line_index,
596: x_return_status => x_return_status);
597:
598: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
599: IF (g_level_error >= g_current_runtime_level ) THEN
600: FND_LOG.STRING(g_level_error,
601: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
602: 'Incorrect return_status after calling ' ||

Line 649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

645: x_product_type => l_product_type,
646: p_inventory_org_id => l_inventory_org_id
647: );
648:
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
650: IF (g_level_error >= g_current_runtime_level ) THEN
651: FND_LOG.STRING(g_level_error,
652: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
653: 'Incorrect return_status after calling ' ||

Line 689: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

685: -- p_org_id => NULL,
686: -- p_default_code => l_user_defined_fisc_class,
687: -- p_return_status => x_return_status);
688: --
689: -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
690: -- IF (g_level_statement >= g_current_runtime_level ) THEN
691: -- FND_LOG.STRING(g_level_statement,
692: -- 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_DET_FACTORS',
693: -- 'Incorrect return_status after calling ' ||

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: EXCEPTION
722:
723: WHEN OTHERS THEN
724:
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MESSAGE.SET_NAME ('ZX','ZX_UNEXPECTED_ERROR');
727: l_context_info_rec.APPLICATION_ID := p_event_class_rec.application_id;
728: l_context_info_rec.ENTITY_CODE := p_event_class_rec.entity_code;
729: l_context_info_rec.EVENT_CLASS_CODE := p_event_class_rec.event_class_code;

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS;

766: l_context_info_rec ZX_API_PUB.context_info_rec_type;
767:
768: BEGIN
769: -- start bug#6503114
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771: -- end bug#6503114
772:
773: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
774: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

832: EXCEPTION
833:
834: WHEN OTHERS THEN
835:
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
838: l_context_info_rec.APPLICATION_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
839: l_context_info_rec.ENTITY_CODE := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);
840: l_context_info_rec.EVENT_CLASS_CODE := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index);

Line 881: x_return_status := FND_API.G_RET_STS_SUCCESS;

877: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
879: END IF;
880:
881: x_return_status := FND_API.G_RET_STS_SUCCESS;
882:
883: -- If Application is PO and Input classification code is Null then default the value.
884: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID(p_trx_line_index) = 201 AND
885: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(p_trx_line_index) IS NULL THEN

Line 965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

961: p_return_status => x_return_status,
962: p_error_buffer => l_error_buffer
963: );
964:
965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
966:
967: IF (g_level_error >= g_current_runtime_level ) THEN
968: FND_LOG.STRING(g_level_error,
969: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.DEFAULT_TAX_CLASSIFICATION',

Line 1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1018: p_document_sub_type,
1019: x_return_status
1020: );
1021:
1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1025: 'after calling default_tax_det_factors RETURN_STATUS = ' || x_return_status);
1026: END IF;

Line 1038: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1034: p_tax_invoice_date,
1035: x_return_status
1036: );
1037:
1038: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1039: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1040: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1041: 'after calling default_tax_reporting_attribs RETURN_STATUS = ' || x_return_status);
1042: END IF;

Line 1052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1048: p_trx_line_index,
1049: x_return_status
1050: );
1051:
1052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1053: IF ( G_LEVEL_error >= G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.STRING(G_LEVEL_error,G_MODULE_NAME||l_api_name,
1055: 'after calling default_tax_classification RETURN_STATUS = ' || x_return_status);
1056: END IF;

Line 1089: x_return_status := FND_API.G_RET_STS_SUCCESS;

1085: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use.BEGIN',
1086: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use(+)');
1087: END IF;
1088:
1089: x_return_status := FND_API.G_RET_STS_SUCCESS;
1090:
1091: -- get tax method
1092: --
1093:

Line 1099: IF x_return_status = FND_API.G_RET_STS_ERROR then

1095: (p_application_id => p_application_id,
1096: p_org_id => p_internal_org_id,
1097: x_product_options_rec => l_zx_proudct_options_rec,
1098: x_return_status => x_return_status);
1099: IF x_return_status = FND_API.G_RET_STS_ERROR then
1100: l_tax_method := 'EBTAX';
1101: ELSE
1102: l_tax_method := l_zx_proudct_options_rec.tax_method_code;
1103: END IF;

Line 1119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1115: p_item_id => p_item_id,
1116: p_default_code => x_intended_use,
1117: p_return_status => x_return_status);
1118:
1119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1120: IF (g_level_statement >= g_current_runtime_level ) THEN
1121: FND_LOG.STRING(g_level_statement,
1122: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_intended_use',
1123: 'Incorrect return_status after calling ' ||

Line 1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1141:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144:
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: x_intended_use := NULL;
1147:
1148: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1149: FND_MSG_PUB.Add;

Line 1187: x_return_status := FND_API.G_RET_STS_SUCCESS;

1183: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code.BEGIN',
1184: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code(+)');
1185: END IF;
1186:
1187: x_return_status := FND_API.G_RET_STS_SUCCESS;
1188:
1189: ZX_GLOBAL_STRUCTURES_PKG.get_product_options_info
1190: (p_application_id => p_application_id,
1191: p_org_id => p_internal_org_id,

Line 1194: IF x_return_status = FND_API.G_RET_STS_ERROR then

1190: (p_application_id => p_application_id,
1191: p_org_id => p_internal_org_id,
1192: x_product_options_rec => l_zx_proudct_options_rec,
1193: x_return_status => x_return_status);
1194: IF x_return_status = FND_API.G_RET_STS_ERROR then
1195: l_tax_method := 'EBTAX';
1196: ELSE
1197: l_tax_method := l_zx_proudct_options_rec.tax_method_code;
1198: END IF;

Line 1210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1206: p_org_id => p_item_org_id,
1207: p_default_code => x_prod_fisc_class_code,
1208: p_return_status => x_return_status);
1209:
1210: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1211: IF (g_level_error >= g_current_runtime_level ) THEN
1212: FND_LOG.STRING(g_level_error,
1213: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1214: 'Incorrect return_status after calling ' ||

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1249: FND_LOG.STRING(g_level_unexpected,
1250: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_prod_fisc_class_code',
1251: 'Unable to default Product Fiscal Classification which is mandatory for LTE');
1252: END IF;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: END;
1256: ELSIF p_item_id IS NOT NULL and p_item_org_id IS NULL THEN
1257:

Line 1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1272: 'JL_ZZ_TAX_VALIDATE_PKG.DEFAULT_TAX_ATTR',
1273: 'Unable to default Product Fiscal Classification ot Trx Business Category'||
1274: ' which is mandatory for LTE');
1275: END IF;
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: END;
1278: END IF;
1279: END IF;
1280:

Line 1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1290:
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293:
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295: x_prod_fisc_class_code := NULL;
1296:
1297: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1298: FND_MSG_PUB.Add;

Line 1337: x_return_status := FND_API.G_RET_STS_SUCCESS;

1333: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value.BEGIN',
1334: 'ZX_DEFAULT_AUTOMATION_PKG.redefault_assessable_value(+)');
1335: END IF;
1336:
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;
1338:
1339: -- Just assign line_amt to the x_assessable_vale. For the logic to get default
1340: -- assessable value will be determinered based on the input parameters
1341: --

Line 1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1351:
1352: EXCEPTION
1353: WHEN OTHERS THEN
1354:
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: x_assessable_value := NULL;
1357:
1358: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1359: FND_MSG_PUB.Add;

Line 1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

1401: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.BEGIN',
1402: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(+)');
1403: END IF;
1404:
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:
1407: l_tax_code_id :=
1408: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.historical_tax_code_id(
1409: p_trx_line_index);

Line 1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1417: l_tax_determine_date,
1418: l_tax_point_date,
1419: x_return_status);
1420:
1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1423: FND_LOG.STRING(g_level_unexpected,
1424: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1425: 'Incorrect return_status after calling ' ||

Line 1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261;

1448: FND_LOG.STRING(g_level_unexpected,
1449: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1450: 'Invalid Tax Code Id: No Record Found');
1451: END IF;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261;
1453: END;
1454:
1455: IF l_effective_from <= l_tax_determine_date AND
1456: (l_effective_to >= l_tax_determine_date OR l_effective_to IS NULL)

Line 1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1465: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1466: 'No Valid Tax Classification Code Found for Tax Code Id: ' ||
1467: l_tax_code_id);
1468: END IF;
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1470: RETURN;
1471: END IF;
1472: END IF;
1473:

Line 1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1489: FND_LOG.STRING(g_level_unexpected,
1490: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po.END',
1491: 'ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po(-)');
1492: END IF;
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1494: RETURN;
1495: END IF;
1496:
1497: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.global_attribute1(

Line 1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1536: FND_LOG.STRING(g_level_unexpected,
1537: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1538: 'Not MTL Item Found');
1539: END IF;
1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1541: END;
1542:
1543: IF l_inv_flag = 'I' THEN
1544:

Line 1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261

1583: FND_LOG.STRING(g_level_unexpected,
1584: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.default_tax_attributes_for_po',
1585: 'Not MTL Item Found');
1586: END IF;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 4893261
1588: END;
1589: END IF;
1590: END IF;
1591:

Line 1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601:
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1603:
1604: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1605: l_context_info_rec.APPLICATION_ID := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index);
1606: l_context_info_rec.ENTITY_CODE := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index);

Line 1657: x_return_status := FND_API.G_RET_STS_SUCCESS;

1653: ' p_internal_org_id := ' || to_char(p_internal_org_id) ||
1654: ' p_legal_entity_id := ' || to_char(p_legal_entity_id) );
1655: END IF;
1656:
1657: x_return_status := FND_API.G_RET_STS_SUCCESS;
1658:
1659: IF p_tax_method_code = 'LTE' THEN
1660:
1661: BEGIN

Line 1671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1667: AND global_attribute_category like 'JL%';
1668:
1669: EXCEPTION
1670: WHEN NO_DATA_FOUND THEN
1671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1672: IF (g_level_statement >= g_current_runtime_level ) THEN
1673: FND_LOG.STRING(g_level_statement,
1674: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1675: 'No COUNTRY_CODE Found For LTE.');

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1674: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1675: 'No COUNTRY_CODE Found For LTE.');
1676: END IF;
1677: WHEN OTHERS THEN
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1679: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1680: FND_LOG.STRING(g_level_unexpected,
1681: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1682: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line 1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1690: FROM XLE_FIRSTPARTY_INFORMATION_V le
1691: WHERE le.legal_entity_id = p_legal_entity_id;
1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: IF (g_level_statement >= g_current_runtime_level ) THEN
1696: FND_LOG.STRING(g_level_statement,
1697: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1698: 'No COUNTRY_CODE Found for EBTax. ');

Line 1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1697: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1698: 'No COUNTRY_CODE Found for EBTax. ');
1699: END IF;
1700: WHEN OTHERS THEN
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1703: FND_LOG.STRING(g_level_unexpected,
1704: 'ZX.PLSQL.ZX_DEFAULT_AUTOMATION_PKG.GET_DEFAULT_COUNTRY_CODE',
1705: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));