DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on ZX_EXEMPTIONS

Line 1177: FROM ZX_EXEMPTIONS EXMP

1173: /*Proceed further only if the exemption id fetched is not null*/
1174: BEGIN
1175: SELECT rate_modifier
1176: INTO x_exempt_record.percent_exempt
1177: FROM ZX_EXEMPTIONS EXMP
1178: WHERE tax_exemption_id = x_exempt_record.exemption_id;
1179: EXCEPTION WHEN NO_DATA_FOUND THEN
1180: IF (g_level_exception >= g_current_runtime_level ) THEN
1181: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

Line 1184: g_string :='No Data found from ZX_EXEMPTIONS for provided id';

1180: IF (g_level_exception >= g_current_runtime_level ) THEN
1181: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1182: END IF;
1183: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184: g_string :='No Data found from ZX_EXEMPTIONS for provided id';
1185: error_exception_handle(g_string);
1186: --x_messages_tbl:=g_messages_tbl;
1187: RETURN;
1188: END;